Intermediate SQL Tutorial | CASE WHEN and SUM() + CASE WHEN

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