DAY 11 | CASE WHEN | 30 Day SQL Challenge | #sql #dataanalytics #dataengineering

💻 Practice SQL for 30 Days with Stephen. In Day 11, we cover CASE WHEN - SQL's version of if/else logic that lets you label rows, create new categories, apply conditional aggregation with COUNT and SUM, handle NULLs inside expressions, and build pivot-style reports right inside your queries. Full exercise included. ⏲️ Timestamps: 0:00 - Intro 12:04 - Simple CASE 17:54 - Searched CASE 24:39 - CASE Inside Aggregates 27:29 - CASE and NULL 43:49 - Building a Complete Profile 44:39 - Exercise 1:01:19 - Recap 📂 Code + datasets: https://github.com/sdw-online/30-Day-SQL-Challenge 🎥 Install PostgreSQL + pgAdmin: https://youtu.be/g8GwhsVPaOg 📩 Join the waitlist: Free community - https://data100x.carrd.co/ Private community - https://data100.carrd.co/ 🎓 Become a data analyst: Analyst Builder - https://www.analystbuilder.com/?via=stephen-david-williams 📲 Socials: LinkedIn - https://www.linkedin.com/in/stephen-david-williams-860428123/ GitHub - https://github.com/sdw-online TikTok - https://www.tiktok.com/@sdw.online Instagram - https://instagram.com/sdw.online Twitter/X - https://twitter.com/sdw_online #sql #dataanalytics #dataengineering #sqlchallenge #casewhen #conditionallogic