Having vs Where Clause in SQL

  It is not a predefined rule but  in a good number of the SQL queries, we use WHERE prior to GROUP BY and HAVING after GROUP BY. The Where clause acts as a pre filter where as Having as a post filter.

https://www.geeksforgeeks.org/having-vs-where-clause-in-sql/