Skip to content
SQLSimplified
hardstorecasepivotgroup-by

Pivot Order Status Counts

Problem

For each product category return completed, cancelled, and pending order counts as separate columns, ordered by category.

Try It

Store (Customers/Orders/Products)

Loading database engine...

Hint

Solution

Search

Search lessons, functions, examples, and practice problems