spotify_play_time_by_age.sql

with
  age_count_per_track as (
    select
      age_at_listen,
      artist,
      track,
      sum(play_time_ms) as sum
    from
      listening_history_cleaned
    group by
      1,
      2,
      3
  ),
  top_song_per_age as (
    select
      age_at_listen,
      artist,
      track,
      sum,
      row_number() over (
        partition by
          age_at_listen
        order by
          sum desc
      ) as rank
    from
      age_count_per_track
  )
select
  *
from
  top_song_per_age
where
  rank = 1