What s the difference b/w HAVING and WHERE ?

Answer 1

Difference between the HAVING and WHERE clause in sql is that the WHERE clause can not be used with aggregates (count, average, min, max, sum, etc) , but the HAVING clause can.