Untitled

 avatar
unknown
plain_text
2 years ago
363 B
6
Indexable
p.name AS playlist_name,
SUM(inv.total) AS total_revenue
FROM track AS t
INNER JOIN invoice_line AS i ON t.track_id=i.track_id
INNER JOIN playlist_track AS pl ON t.track_id=pl.track_id
INNER JOIN playlist AS p ON pl.playlist_id = p.playlist_id
INNER JOIN invoice AS inv ON inv.invoice_id = i.invoice_id
GROUP BY  playlist_name
ORDER BY  total_revenue DESC
Editor is loading...