Show the names of each track and their genre names!
select t1.name, t2.name from tracks as t1 join genres as t2 on t1.genre_id = t2.id;
Show me the names of the tracks that are in the genre Rock!
select t1.name from tracks as t1 join genres as t2 on t1.genre_id = t2.id where t2.name = "Rock";
Show me any names of tracks whose media type is an MPEG audio file!
select t1.name from tracks as t1 join media_types as t2 on t2.id = t1.media_type_id where t2.name = "MPEG audio file";
Can you show a list of both of these names?
select t2.name from genres as t1 join tracks as t2 on t1.id = t2.genre_id join media_types as t3 on t3.id = t2.media_type_id where t1.name = "Rock" or t3.name = "MPEG audio file";