Question: 10. what is the difference between where condition and having clause?
Answer: The difference between WHERE and HAVING clause are: The WHERE clause is used to filter rows before the grouping is performed. The HAVING clause is used to filter rows after the grouping is performed. It often includes the result of aggregate functions and is used with GROUP BY.