Below is an example of a statement that includes both the HAVING and WHERE clause in the same SQL statement.
USE bike;
SELECT category_id, AVG(list_price)
FROM product
WHERE model_year = 2016
GROUP BY category_id
HAVING AVG(list_price) > 1000
Output:
WHERE model_year = 2016
HAVING AVG(list_price) > 1000
This content is provided to you freely by BYU-I Books.
Access it online or download it at https://books.byui.edu/learning_mysql/using_the_having_and.