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

Loading playground environment...

Hint

Solution

Next Problem