Low performers

Find low-performing categories with HAVING.

Low performance

To find low-performance days you use HAVING SUM(amount) < 500.

SELECT sale_date, SUM(amount) AS total
FROM sales
GROUP BY sale_date
HAVING SUM(amount) < 500;

This query returns days with revenue under 500.

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

Low performance — details

Finding low-revenue days helps campaign planning. Filter them with HAVING.

For example, HAVING SUM(amount) < 500 lists the days with total sales below 500; weekends or holidays often show up here.

Exercise Low performance

Find days with revenue under 500 using HAVING SUM(amount) < 500.

Show example solution

SELECT sale_date, SUM(amount) AS total
FROM sales
GROUP BY sale_date
HAVING SUM(amount) < 500;

Test yourself

Add HAVING

SELECT sale_date, SUM(amount) AS total
FROM sales
GROUP BY sale_date
____ SUM(amount) < 500;

Show answer

SELECT sale_date, SUM(amount) AS total
FROM sales
GROUP BY sale_date
HAVING SUM(amount) < 500;

How is low revenue found?
- HAVING SUM < 500
- WHERE COUNT
- ORDER BY DESC
- DISTINCT
Show answer

HAVING SUM < 500 — Filter low totals with HAVING.
Low performers: match the terms

HAVING

filter
SUM

sum
low

small
GROUP BY

group

Next lesson: What is a subquery?

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies