Best sellers

Find the best-selling product with HAVING.

Best seller

To find the best-selling product you use GROUP BY product and HAVING.

SELECT product, SUM(amount) AS total
FROM sales
GROUP BY product
HAVING SUM(amount) > 1000;

This query returns products selling over 1000.

product, SUM(amount) AS total is selected from sales. Rows are grouped by product; aggregate functions are computed per group. HAVING SUM(amount) > 1000 runs after grouping and drops groups that fail the condition.

Best seller — details

HAVING runs after groups are formed. ORDER BY can put the highest total first.

For example, ORDER BY total DESC LIMIT 5 returns the five best-selling products.

Exercise Best seller

Find products with totals over 1000 using HAVING SUM(amount) > 1000.

Show example solution

SELECT product, SUM(amount) AS total
FROM sales
GROUP BY product
HAVING SUM(amount) > 1000;

Test yourself

How do you find the best seller?
- WHERE + COUNT
- DISTINCT
- GROUP BY + HAVING
- JOIN
Show answer

GROUP BY + HAVING — Group by product and filter with HAVING.

Add HAVING

SELECT product, SUM(amount) AS total
FROM sales
GROUP BY product
____ SUM(amount) > 1000;

Show answer

SELECT product, SUM(amount) AS total
FROM sales
GROUP BY product
HAVING SUM(amount) > 1000;

Best sellers: match the terms

GROUP BY

group
HAVING

filter
SUM

sum
ORDER BY

sort

Next lesson: Customer segments

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies