intermediateHAVING 7m est

Categories with Minimum Product Count (Batch 33)

Problem Statement

List all product categories that have more than 1 distinct products in stock. Show the category and product count aliased as `product_count`.

Skills Evaluated

GROUP BYHAVINGCOUNT
Write your SQL query in the editor on the right and click **Run Query**. The system runs your query and compares the result dataset with the official solution. Results must match row-for-row, column-for-column.

Expected Output Format

Executing expected result set...
SQL Query WorkspaceSQLite v3.45 (WASM Mode)
QUICK INSERT:
1