When you use WHERE clause and when you use HAVING clause ?
HAVING clause is used when you want to specify a condition for a group function and it is written after GROUP BY clause
The WHERE� clause is used when you want to specify a condition for columns, single row functions except group functions and it is written before GROUP BY clause if it is used.