How many albums are there?
select count(*) from albums
What are they?
select * from albums
Which ones are made by Billy Cobham?
select * from albums as t1 join artists as t2 on t1.artist_id = t2.id where t2.name = "Billy Cobham";
How many are there?
select count(*) from albums as t1 join artists as t2 on t1.artist_id = t2.id where t2.name = "Billy Cobham";