Pivot Rows into Columns
Talk it through with a coach who asks guiding questions and gives hints until you reach the answer. Pass to mark the challenge as completed.
The problem
- medium
- Pro
Finance wants a report with one row per month and a separate revenue column for each sales channel: web, app and phone. Your data has one row per order with a channel field. Explain how you'd produce this shape in SQL.
Talk this problem through with an AI coach
This is a Pro challenge. Sign in with Google, then upgrade to start a voice session.