Problem 4 of 14 · Pivoting & ReshapingNext: Unpivot category totals back to long form

00:00

Practice / SQL / Pivoting & Reshaping

WorkingGuided

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

Electronics revenue share per month

Per month, return electronics revenue, total revenue across all categories, and electronics' share of the total rounded to 3 decimals. Sort by month.

Returnmonthelectronicstotalelec_share

Columns

cat_monthly3 columns

columntype

categoryVARCHAR

monthDATE

revenueBIGINT

The table

20 rows · 3 columns

cat_monthlyfirst 5 of 20 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