Product Count per Category

Problem

Buying teams at Shopify want to see which categories are overstocked and which ones are understocked. Using the products table, return category and product_count, ordered from most to fewest products.

Schema

products

Sample Data

Expected Output