Multiple choice technology programming languages

Consider the table and query below: Table Name: products category type price indoor kitchen 1.50 outdoor garden 6.00 indoor Bathroom 4.75 outdoor garden 20.20 indoor bathroom 4.25 Office desktop 9.80 SELECT category, COUNT(DISTINCT type) FROM products GROUP BY category How many rows are returned by the SQL statement listed above?

  1. One row

  2. Two rows

  3. Three rows

  4. Four rows
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The GROUP BY category produces one row per distinct category value. The table contains three unique categories: indoor, outdoor, and Office (these are category names in the leftmost column, not types). COUNT(DISTINCT type) counts distinct type values within each category, but this doesn't change the number of rows returned.

Keep practicing — related questions