Question: what is the difference between the where and having clauses?
Answer: A WHERE clause is used is filter records from a result. The filter occurs before any groupings are made. A HAVING clause is used to filter values from a group.