What are all the album names and respective track names?
select t1.title, t2.name from albums as t1 join tracks as t2 on t1.id = t2.genre_id;
Show them ordered by album name!
select t1.title, t2.name from albums as t1 join tracks as t2 on t1.id = t2.genre_id order by t1.title;
Show just the track names for album called "Balls to the Wall"
select t2.name from albums as t1 join tracks as t2 on t1.id = t2.genre_id where t1.title = "Balls to the Wall";