Writing CASE WHEN Statements in SQL (IF/THEN)

[@sarahemslie6105]

An afternoon binge-watching your SQL videos is time well spent! Thank you for taking the time to make them. Subscribed.

[@becomingADS]

That's awesome Sarah!! So happy to have helped ya out!

[@ukaszk.8305]

I'm using your videos as quick (yet pretty comprehensive!) introductions to the topics you cover. For that, you go at a perfect pace and level of detail for me. And you are always to the point, with no excessive intros. Simplicity is great! The overall quality is also pretty good. Thanks a lot for all your work and enthusiasm. Please keep going! :)

[@griffinwillig4329]

Dude, you are legit the best. I have watched so many Coursera's and taken so many classes, and you by-far explain everything THE BEST. Keep on rocking.

[@goldr7198]

Woah, thanks dude! This is way easier to digest than a couple of courses I just read. I don't even understand why they sometimes overcomplicate the examples just to show how advanced and smart the people who understand this topic are.

[@ANUJYADAV-dj1iq]

i have gone through many videos on youtube but I find my solution here at the end. thanks for making this video.

[@stevencarv-buc3163]

*Y repentinamente un comentario en español* xD
Es justo lo que estaba buscando, te agradezco.
Este canal es extremadamente útil.
¡un saludo Nathan!

[@showutheworld]

Your videos are awesome!!! I'm currently taking a course and your second explanation is exactly what I need to understand the concepts better! Thank you! Please continue :) Already subscribed.

[@deadbrain1861]

Thank u I watched all sql playlist u r the best

[@MichaelFlenderson]

Thank you! You’re a good teacher 🙏🏻

[@sailoben]

I have been engaged to Udemy couse on MS SQL server, but some explainations are hard to understand. Whenever I have doubt This is where I go to. Keep making videos please. Thanks

[@andrewkorneychuk586]

Just want to say thank u for this great mysql tutorials

[@vaidehishah8867]

These videos were really helpful! Thanks a ton!

[@max1qin927]

Hi Nathan, your videos are amazing. I watched all about sql and helped me a lot. I find you stop uploading new videos. Could you please do your video again. I am sure they help a lot of people on the planet of Earth.

[@embisonjones4996]

That you Nathan. You’ve earned a new subscriber

[@anne7983]

Just the tutorial I need. Thank you so much!🤩

[@krystianeotis6479]

Your videos have been so helpful. Thank you!!!

[@timothyhallbeck9853]

Good intro into Case, thanks.

[@mazinmohammed6624]

please continue with the database videos, if you could do some on T-SQL and SSM it'd be great!

[@serenereader]

You are an excellent teacher. Thank you!

[@Yarunooo]

SELECT UnitsOnOrder, CASE
WHEN UnitsOnOrder > UnitsInStock THEN 'a'
else 'test'
End as BestellingenStock
FROM Orders;
01:46:40 SELECT UnitsOnOrder, CASE WHEN UnitsOnOrder > UnitsInStock THEN 'a' else 'test' End as BestellingenStock FROM Orders LIMIT 0, 2000 Error Code: 1054. Unknown column 'UnitsOnOrder' in 'field list' 0.016 sec

[@alexg97343]

Great explanation

[@wiktor18071]

Supporting the excellent wrk:)

[@becomingADS]

You're the best!

[@christleiroezi8878]

Hello, I have a huge Case statement query that groups a column into buckets, I am trying to count how many patients are in each bucket, How do I do that?The case statement does let me use the count function. Thanks

[@Hannah-iv6rm]

this is more helpful than my teacher's exp

[@mishraadityaanandeavmjejdt265]

Thank you so much for such a great content . It really helped me a lot.

[@valentinacoy7757]

Your videos are amazing, thank you so much!!!

[@anthonynorman1212]

Your Video was perfect! Thank You

[@butchdavis2062]

Subscribed big time, thank you brother

[@kanknw]

Can you make video about solving complex sql problem

[@higiniofuentes2551]

Thank you for this very useful video!

[@simondreyfuss754]

Jurassic Park: We're gonna make a fortune with this script....

[@LucHayman]

Awesome thank you!
Is it possible to add multiple case statements in one query? How would I do that?

[@96aditishah]

Great explanation! Thanks

[@MohamedIbrahim-pg1rw]

Group By 1 can u pls explain this

[@12245Fred]

Amazing explanation, thank you this helped a lot

[@dawitworku821]

It's very helpful! Thank you.

[@abdulsami5843]

good tutorial, I am a bit confused about the sum(frieght) shouldn't the sum be increasing as we go down ?

[@kellensampson289]

Question: is it possible to then sort out your results so that all the customers within the same weight range are listed together? For example, all the "heavy" customers are ordered first, then all the "medium" customers, then all the "light" customers? All within the same output?

[@ViciousZeroEnder]

if you do order by freight it would effectively do what ur askin

[@montieeaster9883]

Can the Then output be another column rather than a text?

[@charmalvarez9717]

thank you so much, did you stop posting videos?

[@BRAloni]

how to Write a query to display EMPLOYEES having ID 101,102,103 as per the
below order: 1. 101, 2. 103, 3. 102 (Hint: Union Operator / Case Statement)
QUERY

[@JoaoVictor-zq9tj]

Really helpful!!

[@ravinderthakur7973]

Thx a lot, it helps me a lot

[@ashokandhra2268]

Thank you... It's helpful

[@factorise001]

waiting for new videos!!

[@xesiusprime9360]

right on man thanks very helpful and informative supplementation of my education when i dont understand them in how they describe it
btw im wondering, I am almost done my SQL and i heard that i could find a foot in the door kind of job with just SQL. Is this true? how do i find it?

[@蔡佩儒-z5b]

good job

[@manavsaxena5579]

Hey man, awesome tutorials. Is there anything coming on Window Functions?

[@danielmejia8530]

Very Nice. Can I use logic after WHEN? let's say: WHEN (condition_A AND condition_B) THEN something.

[@vigneshiyer2424]

Yes, you can.

[@karlderkastn7012]

tomorrow is my final exam, thanks :)

[@attrinh8343]

verry good content

[@AngeloMendoza-e3p]

Thank you so much for the help

[@ViciousZeroEnder]

DO MORE SQL VIDEOS PLEASE!!!!

[@nunesburicato3199]

good work

[@MartinFaehrmann]

Very helpful video, thank you :)

[@itzyfan88]

Very clear, thanks

[@jordanroywhite]

Thanks so much for the great video!

[@gonzalomartinez1575]

Thanks very useful

[@pv6010]

u r the man, thankxxxxxxx

[@FitzJeral784]

great video, thank you!

[@andyn6053]

more sql videos pls :)

[@languagesandotherstuffs3305]

Thank you

[@KevinTempelx]

Thanks!

[@Leopar525]

I love your content but you should zoom in a bit.. too much empty space and we cannot see the letters without high definition when on mobile

[@yotsusan_machi]

thank kyu mr

Thanks

[@prasadkhairnar7915]

thanks : )

[@praji1202]

Where is the if condition?

[@Leopar525]

I love your content but you should zoom in a bit.. too much empty space and we cannot see the letters without high definition when on movile

[@Helloimtheshiieet]

Ok... but not if you do case when XYZ AND ABC then 1 else 0...

[@BessieMartin-cl8sz]

interest!

[@mujtaba135]

Need Help !!!!!!!!!!!

[@harshavardhank9915]

please use single quotes otherwise it won't work

[@nextdoortechieaminfirnash6002]

It was right to the point. Thank you for a wonderful lesson.

[@adityadalvi7884]

Thanks

[@Leopar525]

I love your content but you should zoom in a bit.. too much empty space and we cannot see the letters without high definition when on mobile