CREATE TABLE albums (title VARCHAR2, id VARCHAR2)
CREATE TABLE tracks (album_id VARCHAR2)

List title of albums have the number of tracks greater than 10.
SELECT T1.title FROM albums AS T1 JOIN tracks AS T2 ON T1.id = T2.album_id GROUP BY T1.id HAVING COUNT(T1.id) > 10
SELECT "T1"."title" FROM "albums" "T1" JOIN "tracks" "T2" ON "T1"."id" = "T2"."album_id" GROUP BY "T1"."id" HAVING COUNT("T1"."id") > 10