Count products by category · Study guide
Identify the required rows and columns and decide how to group the conditions. Open the practice screen to write SQL and inspect the results.
From Products(products), show Category(category) → count (all rows) in this order. Group rows with the same Category(category).
Learning objectives and tables
- Category (category)
- count (all rows)
- Category (category)
products (Products): id (ID), name (Name), category (Category), price (Price (KRW)), stock (Stock)
Concepts to review
Practice: Count products by category
Practice opens in this page’s language. Change it in the practice options at any time.