SQL Server Queries Part 5 - CASE Expressions

By Andrew Gould

A written version of this tutorial can be found at:

You can download the script to create the Movies database used in this video at the following link:

You can see the range of resources and courses we offer in SQL Server here:

[Z.Canvas]

where have your videos been all my life? 😭this is so well explained. Thank you!🌸✨

[SuzanneBrown-ds]

I've been a fan since 2014, learning Excel VBA. LOVE your explanation style.

[ComandanteJ]

almost 6 months of classes (6 hours a week), and you just made everything clear in less than an hour worth of vids. I dont know if my teacher is bad or you're very good... probably both, LOL. Anyway, great vids! And long live 80's action flicks!

[teenytinytoons]

one of the best teachers out there. concise and extremely clear. everything just clicks. this guy absolutely hates 'twilight.' I'm dead. that was f hysterical.

[aaronag]

This was the most well explained example of the CASE statement I have found on YouTube and on any course on Udemy or datacamp. Thank you so much. I will now watch your other videos.

[franzbiberkopf]

Your T-Sql tutorials are absolutely the best on the Tube, Sir! Many thanks for it! Greetings from Rome, Italy.

[bruisedhelmet]

Awesome series of videos but the hit on the Twilight movies is much appreciated.

[JNguyen]

I've been watching the entire series including SSIS and SSRS and I'm glad you included humor to the videos. It makes them that much more enjoyable.

Great job, you made it easier for young professionals like myself to enter into the Data world : )

Ps. This is a fine example of CASE statements along with a perfect example of "Hating" lol.

[hicthed]

Thank you so much for the videos! You have no idea how much this is helping me for my competitions!!! :)

[PokeTwilight]

OMG You video helped me a lot! Thanks for that brilliant and well detailed explanation! You've earned another subscriber!

[hemantgs]

simply best way to explain, really worth to know

[yveshermann]

GREAT CHANNEL im learning a lot on it ..very well explained. twilight example was hilarious ...lool

[sayedraminSadat]

Excellent Tutorials for beginners. Thank you!

[fariheyd]

Brilliant! Thank you very much for concise content.

[christopherlopez]

6:06 "A simple description of that film. That's a fairly fair and accurate description of that film." lol good example

[ryanrice]

Dude the Twilight comments have me rolling. Lol

[rajeevrawat]

You are doing a really great ....your''s video helped me a lot

[bevdec]

I can't thank you enough. This was so helpful !

[dtntracer]

Hey! It´s very good video! Thank you.
I could not find a key how to set up into my SQL Querry something more then SFW.
Now I´m gonna be SQL master :)

[fernandocamargo]

2019 - Best Tutorial Teacher ever, another thing I could notice is that He hates twilight movies hahaha...I completely agree, awful!