#sql

Difference between where clause and having clause in sql
------------------------------------------------------------------------------------------------------------------------
WHERE clause allows you to filter data from specific rows (individual rows) from a table based on certain conditions
The WHERE clause is applied before the GROUP BY clause.
------------------------------------------------------------------------------------------------------------------------------------
HAVING clause allows you to filter data from a group of rows in a query based on conditions involving aggregate values
The HAVING clause is applied after the GROUP BY clause.