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"
albums of Billy Cobham refers to selecting records from a table named albums where the artist's name is Billy Cobham; need to join albums table with artists table on artist_id to match artist's name;