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.

[@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

[@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!

[@deadbrain1861]

Thank u I watched all sql playlist u r the best

[@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.

[@MichaelFlenderson]

Thank you! You’re a good teacher 🙏🏻

[@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.

[@andrewkorneychuk586]

Just want to say thank u for this great mysql tutorials

[@embisonjones4996]

That you Nathan. You’ve earned a new subscriber

[@anne7983]

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

[@Hannah-iv6rm]

this is more helpful than my teacher's exp

[@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

[@kanknw]

Can you make video about solving complex sql problem

[@krystianeotis6479]

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

[@timothyhallbeck9853]

Good intro into Case, thanks.

[@serenereader]

You are an excellent teacher. Thank you!

[@anthonynorman1212]

Your Video was perfect! Thank You

[@alexg97343]

Great explanation

[@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

[@charmalvarez9717]

thank you so much, did you stop posting videos?

[@MohamedIbrahim-pg1rw]

Group By 1 can u pls explain this

[@LucHayman]

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

[@wiktor18071]

Supporting the excellent wrk:)

[@becomingADS]

You're the best!

[@valentinacoy7757]

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

[@higiniofuentes2551]

Thank you for this very useful video!

[@butchdavis2062]

Subscribed big time, thank you brother

[@montieeaster9883]

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

[@simondreyfuss754]

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

[@mazinmohammed6624]

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

[@96aditishah]

Great explanation! Thanks

[@dawitworku821]

It's very helpful! Thank you.

[@JoaoVictor-zq9tj]

Really helpful!!

[@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?

[@abdulsami5843]

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

[@ravinderthakur7973]

Thx a lot, it helps me a lot

[@mishraadityaanandeavmjejdt265]

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

[@manavsaxena5579]

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

[@AngeloMendoza-e3p]

Thank you so much for the help

[@ashokandhra2268]

Thank you... It's helpful

[@karlderkastn7012]

tomorrow is my final exam, thanks :)

[@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

[@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

[@12245Fred]

Amazing explanation, thank you this helped a lot

[@danielmejia8530]

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

[@vigneshiyer2424]

Yes, you can.

[@itzyfan88]

Very clear, thanks

[@jordanroywhite]

Thanks so much for the great video!

[@ViciousZeroEnder]

DO MORE SQL VIDEOS PLEASE!!!!

[@MartinFaehrmann]

Very helpful video, thank you :)

[@蔡佩儒-z5b]

good job

[@FitzJeral784]

great video, thank you!

[@attrinh8343]

verry good content

[@pv6010]

u r the man, thankxxxxxxx

[@gonzalomartinez1575]

Thanks very useful

[@factorise001]

waiting for new videos!!

[@nunesburicato3199]

good work

[@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

[@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

[@praji1202]

Where is the if condition?

[@andyn6053]

more sql videos pls :)

[@languagesandotherstuffs3305]

Thank you

[@KevinTempelx]

Thanks!

[@Helloimtheshiieet]

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

[@prasadkhairnar7915]

thanks : )

[@yotsusan_machi]

thank kyu mr

Thanks

[@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.

[@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

[@adityadalvi7884]

Thanks