What is the difference between using the WHERE clause and the HAVING clause?

What will be an ideal response?

The HAVING clause is similar to the WHERE clause. However, the WHERE clause restricts the results based on individual row values. Another way of saying this is that the WHERE clause can eliminate records from the results before the aggregates are calculated. The HAVING clause eliminates entire groups of records from the results based on the aggregated calculations. Because the HAVING clause works on aggregated rows, it always uses an aggregate function as its test.