I have some problems with one of the questions of the less common joins assesment.
Link to question 3:
My Code for question 3:
SELECT g.name AS genre, SUM(i.total) AS total_revenue FROM genre AS g LEFT JOIN track AS t ON g.genre_id = t.genre_id LEFT JOIN invoice_line AS il ON t.track_id = il.track_id LEFT JOIN invoice as i ON i.invoice_id = il.invoice_id GROUP BY g.name;
What actually happened:
Why do I get the feedback that I’m not joining the correct tables and do not use the correct join constraints?