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! :)

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

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

[@ANUJYADAV-dj1iq]

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

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

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

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

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

[@vaidehishah8867]

These videos were really helpful! Thanks a ton!

[@MichaelFlenderson]

Thank you! You’re a good teacher 🙏🏻

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

[@krystianeotis6479]

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

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

[@Hannah-iv6rm]

this is more helpful than my teacher's exp

[@timothyhallbeck9853]

Good intro into Case, thanks.

[@valentinacoy7757]

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

[@mazinmohammed6624]

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

[@higiniofuentes2551]

Thank you for this very useful video!

[@LucHayman]

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

[@anthonynorman1212]

Your Video was perfect! Thank You

[@kanknw]

Can you make video about solving complex sql problem

[@mishraadityaanandeavmjejdt265]

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

[@butchdavis2062]

Subscribed big time, thank you brother

[@dawitworku821]

It's very helpful! Thank you.

[@manavsaxena5579]

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

[@wiktor18071]

Supporting the excellent wrk:)

[@becomingADS]

You're the best!

[@12245Fred]

Amazing explanation, thank you this helped a lot

[@96aditishah]

Great explanation! Thanks

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

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

[@abdulsami5843]

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

[@simondreyfuss754]

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

[@charmalvarez9717]

thank you so much, did you stop posting videos?

[@ravinderthakur7973]

Thx a lot, it helps me a lot

[@MartinFaehrmann]

Very helpful video, thank you :)

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

[@jordanroywhite]

Thanks so much for the great video!

[@ashokandhra2268]

Thank you... It's helpful

[@danielmejia8530]

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

[@vigneshiyer2424]

Yes, you can.

[@JoaoVictor-zq9tj]

Really helpful!!

[@karlderkastn7012]

tomorrow is my final exam, thanks :)

[@AngeloMendoza-e3p]

Thank you so much for the help

[@MohamedIbrahim-pg1rw]

Group By 1 can u pls explain this

[@montieeaster9883]

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

[@FitzJeral784]

great video, thank you!

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

[@itzyfan88]

Very clear, thanks

[@ViciousZeroEnder]

DO MORE SQL VIDEOS PLEASE!!!!

[@factorise001]

waiting for new videos!!

[@attrinh8343]

verry good content

[@gonzalomartinez1575]

Thanks very useful

[@pv6010]

u r the man, thankxxxxxxx

[@蔡佩儒-z5b]

good job

[@nunesburicato3199]

good work

[@andyn6053]

more sql videos pls :)

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

[@languagesandotherstuffs3305]

Thank you

[@KevinTempelx]

Thanks!

[@yotsusan_machi]

thank kyu mr

[@Helloimtheshiieet]

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

Thanks

[@prasadkhairnar7915]

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