195
LESQL for absolute beginners – Part 16 🖥️
Can you group your data by department in SQL? Most beginners do it row by row. 😅
GROUP BY does it in ONE query ⚡
1️⃣ GROUP BY — groups rows that share the same value
2️⃣ GROUP BY + COUNT(*) — count employees per department
3️⃣ GROUP BY + HAVING — filter groups after grouping 🎯
SELECT Dept, SUM(Salary)
FROM Employees
GROUP BY Dept
HAVING SUM(Salary) > 150000;
→ IT: 176K ✓ | Finance: 154K ✓
16 out of 25 SQL basics — 64% there 🔥
Have you ever used GROUP BY at work? Drop a comment! 💬
Follow @learnsqleasy 👣 | Save this reel 🔖
Next up: Part 17 – HAVING 🚀
#techeducation #datanalytics #sqlforbeginners #sqlbasics #learnsql
@learnsqleasy
