Difference between  WHERE  and HAVING :

WHERE Clause:-

1.       It selects rows before grouping.

2.       It can not contain aggregate function.

HAVING Clause :-

1.        It selects rows after grouping.

2.       It is used for filtering groups in the SQL