I am interested in learning who the artist is.
select t2.name from album as t1 join artist as t2 on t1.artistid = t2.artistid where t1.title = "Balls to the Wall"
That's okay. What are some of Accept's other albums?
select t1.title from album as t1 join artist as t2 on t1.artistid = t2.artistid where t2.name = "Accept" and t1.title ! = "Balls to the Wall"
That sounds good. What about the album "For Those About To Rock, We Salute You"? Which artist produced that one?
select t2.name from album as t1 join artist as t2 on t1.artistid = t2.artistid where t1.title = "For those about to rock we salute You"