What genre names for each track by track name!
select t1.name, t2.name from genres as t1 join tracks as t2 on t1.id = t2.genre_id where t1.name = "Rock"
Show us all the tracks that belong to genre Rock.
select t2.name from genres as t1 join tracks as t2 on t1.id = t2.genre_id where t1.name = "Rock"
How about those that belong to genre Jazz.
select t2.name from genres as t1 join tracks as t2 on t1.id = t2.genre_id where t1.name = "Jazz"
Which ones belong to either one?
select t2.name from genres as t1 join tracks as t2 on t1.id = t2.genre_id where t1.name = "Rock" or t1.name = "Jazz"