Question: what is the difference between where clause and having clause?
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.