WHERE is used for filtering rows, HAVING is used for filtering groupsa.Falseb.True

Step 1: Break Down the Problem

The question is asking whether the statement "WHERE is used for filtering rows, HAVING is used for filtering groups" is true or false.

Step 2: Relevant Concepts

1. WHERE Clause: This clause is used in SQL to filter records from a result set based on specified conditions. It applies to individual rows before any grouping takes place.

2. HAVING Clause: This clause is used to filter records after the grouping occurs. It is particularly useful when working with aggregate functions (like COUNT, SUM, AVG) that are applied to groups of rows.

Step 3: Analysis and Detail

• Filtering with WHERE: When you use the WHERE clause, you're filtering the data based on specific criteria directly on the rows in your database.

• Filtering with HAVING: When you apply the HAVING clause, it's generally after you've used GROUP BY to form groups of rows. This allows you to filter based on the result of the aggregate functions applied to those groups.

Step 4: Verify and Summarize

The distinction between WHERE and HAVING is crucial in SQL queries. The statement outlined in the question accurately reflects the functionality of both clauses.

Final Answer

b. True - WHERE is used for filtering individual rows, while HAVING is used for filtering based on groups or aggregated results.