Devices by age group

MediumNetflixjoinspivotconditional counts· 20 XP

Netflix's product team is deciding which apps to improve first. They want to know how each age group splits its viewing across devices.

For each age_group, show the number of watch sessions on each device as columns: TV, Mobile, Laptop and Tablet.

Expected output

  • Any row order

Example of the shape (made-up values):

age_group tv mobile laptop tablet
18-24 300 410 150 40

Hints, the later steps and the answer come with Pro.

Write your query here. Ctrl + Enter submits.