Tell me the artist id and album id for title Balls to the Wall ?
select albumid, artistid from album where title = 'Balls to the Wall'
k. Who is the composer for For Those About To Rock (We Salute You) ?
select distinct t2.composer from album as t1 join track as t2 on t1.albumid = t2.albumid where t1.title = 'For those about to rock we salute You'
k. Who is the composer for Balls to the Wall ?
select distinct t2.composer from album as t1 join track as t2 on t1.albumid = t2.albumid where t1.title = 'Balls to the Wall'
* I have left the chat *
select t1.title, t2.albumid, count ( * ) from album as t1 join track as t2 on t1.albumid = t2.albumid group by t2.albumid