jazzTracks example in PRQL

jazzTracks.prql

# Try this for yourself at: https://prql-lang.org/playground/

let arr_agg = func x -> s"array_agg({x})"

let jazzTracks = (
  from t=tracks 
  join g=genres (==genre_id && g.name=="Jazz")
  select {t.*, genre=g.name}
  )

from a=albums
join s=artists (==artist_id)
join j=jazzTracks (j.album_id==a.album_id)
group {AlbumTitle = a.title, Artist = s.name} (
  aggregate {
    JazzTracks=(arr_agg f"{{Name='{j.name}',UnitPrice={j.unit_price}}}")
    }
  )
sort Artist