Problem 5 of 14 · Pivoting & ReshapingNext: Crosstab with row totals and a grand-total row

00:00

Practice / SQL / Pivoting & Reshaping

WorkingGuided

MediumAbout 10 minPivoting & ReshapingLesson: Pivoting & Reshaping (P20) →

Unpivot category totals back to long form

The inverse of a pivot. First build one wide row of per-category totals (electronics, books, clothing), then unpivot it back to long form: one row per category with columns category, total. Sort by category.

Columns

cat_monthly3 columns

columntype

categoryVARCHAR

monthDATE

revenueBIGINT

The table

18 rows · 3 columns

cat_monthlyfirst 5 of 18 rows

categorymonthrevenue

electronics2025-12-011200

electronics2026-01-011100

electronics2026-02-011300

electronics2026-03-011500

electronics2026-04-011400

If you get stuck

Show hint · 1 hint Walkthrough Reveal answer

Your query · runs in your browser⌘ Enter to run

Loading editor…

Output · run to see rows