```html

Focus Keyword: WHERE vs HAVING in SQL Queries

In SQL queries, the WHERE and HAVING clauses are used to filter and restrict data retrieval, but they are used in different contexts.

WHERE Clause:

The WHERE clause is used to filter records based on specific conditions before the data is grouped or aggregated. It is used with SELECT, DELETE, and UPDATE statements to specify the criteria for selecting rows.

HAVING Clause:

The HAVING clause is used to filter records after the data is grouped, typically used with the GROUP BY clause. It is applied to aggregated functions, such as COUNT, SUM, AVG, etc., and filters the result set based on the specified condition.

Therefore, the main difference between WHERE and HAVING clauses is their timing of operation - WHERE filters individual rows before grouping, while HAVING filters grouped rows after aggregation.

```