How many different albums are there?
select count(*) from albums;
What are the titles of the albums?
select title from albums;
What are the names of the artists for each!
select t1.title, t2.name from albums as t1 join artists as t2 on t1.artist_id = t2.id;
Show me only the album titles by the artist named Aerosmith!
select t1.title from albums as t1 join artists as t2 on t1.artist_id = t2.id where t2.name = "Aerosmith";