What tracks belong to genre Rock?
select * from genres as t1 join tracks as t2 on t1.id = t2.genre_id where t1.name = "Rock"
What are the names of tracks that are Rock or MPEG media type?
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"
What are the names of tracks that belong to the genre Rock and are media type MPEG audio file?
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"
How many distinct media types are Rock genre?
select count ( distinct t2.media_type_id ) 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"
What is the most common media type for the Rock genre?
select * 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" group by t3.id order by count ( * ) desc limit 1