what is the difference between having and where?

Answer 1

maybe this will help ....

https://stackoverflow.com/questions/287474/whats-the-difference-between-having-and-where

Answer 2

you can use WHERE in general, but when you use GROUP BY you cannot use WHERE you should use HAVING instead