CREATE TABLE albums (aid VARCHAR2)
CREATE TABLE tracklists (albumid VARCHAR2, songid VARCHAR2)
CREATE TABLE songs (title VARCHAR2, songid VARCHAR2)

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"