Intermediate SQL Tutorial | CASE WHEN and SUM() + CASE WHEN
Details
| Title | Intermediate SQL Tutorial | CASE WHEN and SUM() + CASE WHEN |
| Author | Data Engineering With David |
| Duration | 12:16 |
| File Format | MP3 / MP4 |
| Original URL | https://youtube.com/watch?v=abe_-AIHBMc |
🎵 Support the artists — buy the original for the best audio quality! 🎵
Description
This video covers the CASE WHEN statement in SQL, as well as how to use SUM() + CASE WHEN. We cover CASE WHEN syntax and common use cases.
00:00:00 Introduction
00:16:00 The US Airports Dataset
00:01:10 Creating a flag with CASE WHEN
00:05:05 Using SUM() with CASE WHEN
00:07:32 Bucketing data using CASE WHEN