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
On this page of the site you can watch the video online Intermediate SQL Tutorial | CASE WHEN and SUM() + CASE WHEN with a duration of hours minute second in good quality, which was uploaded by the user Data Engineering With David 26 September 2023, share the link with friends and acquaintances, this video has already been watched 617 times on youtube and it was liked by 25 viewers. Enjoy your viewing!