Question: what is the difference between having and where clause?
Answer: Difference between WHERE and HAVING clause in SQL? The main difference between WHERE and HAVING clause comes when used together with GROUP BY clause, In that case WHERE is used to filter rows before grouping and HAVING is used to exclude records after grouping.