CREATE TABLE artists (id VARCHAR, name VARCHAR)
CREATE TABLE albums (artist_id VARCHAR)

How many albums does Billy Cobham has?
SELECT COUNT(*) FROM albums AS T1 JOIN artists AS T2 ON T1.artist_id = T2.id WHERE T2.name = "Billy Cobham"
SELECT COUNT(*) FROM "albums" AS "T1" JOIN "artists" AS "T2" ON "Billy Cobham" = "T2"."name" AND "T1"."artist_id" = "T2"."id"