GROUP BY

Aggregate rows by a column

Aggregation

SQL

SELECT department, COUNT(*) as count, AVG(salary) as avg_salary
FROM employees
GROUP BY department;

What each clause does

GROUP BY groups rows by department. COUNT(*) counts rows per group. AVG(salary) computes the average salary per department.

Related tools

SQL Formatter SQL Syntax Cheatsheet

Other SQL examples

SELECT All Rows SELECT with WHERE INSERT INTO UPDATE SET DELETE FROM INNER JOIN LEFT JOIN ORDER BY Subquery CREATE TABLE Common Table Expression (CTE)Window Function UPSERT (ON CONFLICT)LIMIT & OFFSET