Loading this exercise…

Category Counts In A Subquery

#2 · 2 of 10Free sample

Instructions

Category Counts In A Subquery

For each category, we want category_id, category_name, and a computed column showing how many products belong to that category. Use a subquery in the SELECT clause to count products for each category.

Loading the practice editor and dataset…

Sign up to unlock

The reference answer is one attempt away.

Create a free account to save your progress and reveal the worked answer for this free exercise. The complete practice library is available with Practice Pass or Mastery.

Save attempts and completed exercises
Reveal this free exercise's answer after an attempt
Return to your progress from any device
Free forever — no credit card

Create free account →Already a member? Log in →

Inline View Of Cheap Products

Tables

11 tables · 52 columns

customers7 cols

customer_idINTEGER
first_nameTEXT
last_nameTEXT
emailTEXT
cityTEXT
join_dateTEXT
phoneTEXT

departments3 cols

department_idINTEGER
department_nameTEXT
locationTEXT

employees6 cols

employee_idINTEGER
first_nameTEXT
last_nameTEXT
department_idINTEGER
hire_dateTEXT
salaryREAL

categories2 cols

category_idINTEGER
category_nameTEXT

products6 cols

product_idINTEGER
product_nameTEXT
category_idINTEGER
unit_priceREAL
stock_quantityINTEGER
creation_dateTEXT

orders6 cols

order_idINTEGER
customer_idINTEGER
employee_idINTEGER
order_dateTEXT
statusTEXT
total_amountREAL

order_items4 cols

order_idINTEGER
product_idINTEGER
quantityINTEGER
unit_priceREAL

suppliers4 cols

supplier_idINTEGER
supplier_nameTEXT
cityTEXT
products_suppliedTEXT

shipping_addresses6 cols

shipping_idINTEGER
order_idINTEGER
addressTEXT
cityTEXT
stateTEXT
postal_codeTEXT

inventory_movements5 cols

movement_idINTEGER
product_idINTEGER
change_quantityINTEGER
movement_dateTEXT
reasonTEXT

cities3 cols

city_idINTEGER
city_nameTEXT
stateTEXT