@jessramosdata: SQL in 60 Episode 4: Group By in SQL Link in bio for my free intro course to start learning the most in demand skill to be a high-paid data analyst 💰 Group By is how you go from raw rows ➡️ summarized insights. They work hand-in-hand with aggregate functions because group by specifies how to segment and partition the data (by product or customer for example), and aggregate functions specify the calculation. Aggregate Functions that work well w/ GROUP BY: ✨ COUNT() for counting rows or items ✨ SUM() for total values ✨ AVG() for averages ✨ MAX() and MIN() for the range of values Business Questions you can answer: 💰 Count sales by region 💰 Average revenue per customer? 💰 Sum purchases by product? ⚠️ CAUTION: Every column in your SELECT clause must either be: 1. Inside an aggregate function (like SUM, COUNT, etc.) 2. Listed in the GROUP BY clause Or you’ll get an error! 😡 Which aggregate functions work well with group by? 👇🏼 #sql #dataanalytics #datascience #sqlin60
