SQL Basics - SQL online course | LearnSQL.com

PHOTO EMBED

Tue Aug 09 2022 08:19:41 GMT+0000 (UTC)

Saved by @vnmshenoy

​SELECT  department,count(*) as employees_no
FROM employees
WHERE year=2013
GROUP BY department
content_copyCOPY

group by and where.Where comes first followed by groupby

https://learnsql.com/track/sql-from-a-to-z/course/sql-queries/order-by-group-by/group-by/group-by