GROUP BY groups rows with the same values into summary rows. Essential for creating reports and analyzing data patterns.

Basic GROUP BY Syntax

SELECT column, COUNT(*) FROM table GROUP BY column;

COUNT with GROUP BY

SELECT country, COUNT(*) as customer_count

FROM customers

GROUP BY country;

SUM with GROUP BY

SELECT category, SUM(sales) as total_sales

FROM products

GROUP BY category;

AVG with GROUP BY

SELECT department, AVG(salary) as avg_salary

FROM employees

GROUP BY department;

GROUP BY with HAVING

SELECT category, COUNT(*) as product_count

FROM products

GROUP BY category

HAVING COUNT(*) > 10;

Multiple Column GROUP BY

SELECT country, city, COUNT(*) as customers

FROM customers

GROUP BY country, city;

Generate GROUP BY Queries

Need aggregations? Tell AI2sql what summary you need in plain English.