CREATE TABLE vocals (songid NUMBER, bandmate NUMBER, type CLOB)
CREATE TABLE instruments (songid NUMBER, bandmateid NUMBER, instrument CLOB)
CREATE TABLE tracklists (albumid NUMBER, position NUMBER, songid NUMBER)
CREATE TABLE band (id NUMBER, firstname CLOB, lastname CLOB)
CREATE TABLE performance (songid NUMBER, bandmate NUMBER, stageposition CLOB)
CREATE TABLE albums (aid NUMBER, title CLOB, year NUMBER, label CLOB, type CLOB)
CREATE TABLE songs (songid NUMBER, title CLOB)

Find the number of songs in all the studio albums.
SELECT COUNT(DISTINCT T3.title) FROM albums AS T1 JOIN tracklists AS T2 ON T1.aid = T2.albumid JOIN songs AS T3 ON T2.songid = T3.songid WHERE t1.type = "Studio"
SELECT COUNT(DISTINCT "T3"."title") FROM "albums" "T1" JOIN "tracklists" "T2" ON "T1"."aid" = "T2"."albumid" JOIN "songs" "T3" ON "T2"."songid" = "T3"."songid" WHERE "Studio" = "t1"."type"