Question: in a select query what is the difference between a where clause and a having clause?
Answer: The WHERE clause is used to filter individual rows using either a comparison to a literal, or a comparison to another column. The HAVING clause is used to filter groups of rows using an aggregate expression. Often, the same aggregate expression is in the SELECT list.