Product Count per Category

Problem

Product catalogues are organized by category, and understanding how inventory is distributed helps buying teams decide where to expand or trim the assortment. Category managers run this query regularly to spot over-stocked categories and gaps that need new products. Using the products table, return category and product_count, ordered from most to fewest products.

Schema

products

Sample Data

Expected Output