SQL Filter results using WHERE and HAVING
Syntax
- SELECT column_name
FROM table_name
WHERE column_name operator value - SELECT column_name, aggregate_function(column_name)
FROM table_name
GROUP BY column_name
HAVING aggregate_function(column_name) operator value
