Untitled
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...