Find the titles of all the albums of the artist AC/DC?
select title from album as t1 join artist as t2 on t1.artistid = t2.artistid where t2.name = "AC/DC"
Find the titles of all the albums of the artist Aerosmith please?
select title from album as t1 join artist as t2 on t1.artistid = t2.artistid where t2.name = "Aerosmith"
What are the titles of all the albums by artist id 4?
select title from album where artistid = 4