- SELECT t.name AS playlist_name,
- SUM(t.unit_price) 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
- GROUP BY playlist_name-- добавьте поле для группировки
- ORDER BY SUM(t.unit_price) DESC -- добавьте поле для сортировки;
