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.

Start free →