Show me all the tracks names and their media types!
select t1.name, t2.name from tracks as t1 join media_types as t2 on t2.id = t1.media_type_id;
Which ones are MPEG files?
select t1.name, t2.name from tracks as t1 join media_types as t2 on t2.id = t1.media_type_id where t2.name = "MPEG audio file";
Also provide the genres for each of these!!
select t1.name, t2.name, t3.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 t3.name = "MPEG audio file";
Which names of the ones are in the genre Rock?
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" and t3.name = "MPEG audio file";