i can't understand what I am doing wrong. The results seem ok

the question is: We will be writing ONLY the SQL query for this challenge. The library database contains a Media table with the columns media_id, title, img, format, year and category. It also contains a Genres table with the columns genre_id and genre. To join these tables, there is a Media_Genres table that contains the column media_id and genre_id Add to the following SELECT statement to JOIN the Media table and the Genres table using the joining table Media_Genres. SELECT * FROM Media WHERE media_id=3; NOTE: You will need to add the table to the WHERE clause so that the media_id column is not ambiguous.

My answer is: SELECT * FROM ((Media JOIN Media_Genres ON Media.media_id = Media_Genres.media_id) JOIN genres ON Media_Genres.genre_id = Genres.genre_id) WHERE Media.media_id=3;

the results seem ok, but it keeps telling me that i need to join the genres table. the results look like this: media_id title img genre_id format year category media_id genre_id genre_id genre 3 Refactoring: Improving the Design of Existing Code img/media/refactoring.jpg 17 Hardcover 1999 Books 3 51 51 Business 3 Refactoring: Improving the Design of Existing Code img/media/refactoring.jpg 17 Hardcover 1999 Books 3 17 17 Tech