For each track, show the track name and album name!
select t1.name, t2.title from tracks as t1 join albums as t2 on t1.album_id = t2.id;
Also include the genre name !
select t3.name, t1.name, t2.title from tracks as t1 join albums as t2 on t1.album_id = t2.id join genres as t3 on t1.genre_id = t3.id;
Show just the ones of the genre named Rock!
select t3.name, t1.name, t2.title from tracks as t1 join albums as t2 on t1.album_id = t2.id join genres as t3 on t1.genre_id = t3.id where t3.name = "Rock";
Show just the track names!
select t2.name from genres as t1 join tracks as t2 on t1.id = t2.genre_id where t1.name = "Rock";