SELECT g.name, SUM(il.quantity*il.unit_price) AS total_purchased FROM invoice_line AS il JOIN track AS t ON t.track_id=il.track_id JOIN genre AS g ON t.genre_id=g.genre_id GROUP BY g.name
What I expected to happen:
Complete the exercise
What actually happened:
The query selected fewer rows than we expected. It should have selected 25 rows but instead, it selected 18 rows.
Im stuck guys, can you help me?