Show the albums of Billy Cobham.
select * from albums as t1 join artists as t2 on t1.artist_id = t2.id where t2.name = "Billy Cobham"
Count the albums of Billy Colham.
select count ( * ) from albums as t1 join artists as t2 on t1.artist_id = t2.id where t2.name = "Billy Cobham"
Name of the album.
select t1.title from albums as t1 join artists as t2 on t1.artist_id = t2.id where t2.name = "Billy Cobham"