CREATE TABLE table_name_44 (album VARCHAR2, release_type VARCHAR2)

What was the name of the album that was a demo release?
SELECT album FROM table_name_44 WHERE release_type = "demo"
SELECT "album" FROM "table_name_44" WHERE "demo" = "release_type"