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