Billy Cobham มีกี่อัลบั้ม?ไม่จำเป็นต้องใช้ตารางทั้งหมด
How many albums does Billy Cobham has?It is not neccessary to use all the tables.
 artists:  (id [ VARCHAR ] name [ VARCHAR) ]
SELECT COUNT(*) FROM albums AS T1 JOIN artists AS T2 ON T1.artist_id = T2.id WHERE T2.name = "Billy Cobham"