CREATE TABLE table_name_95 (album VARCHAR, note VARCHAR)

Which album had the note tape [tape echo]?
SELECT album FROM table_name_95 WHERE note = "tape [tape echo]"
SELECT "album" FROM "table_name_95" WHERE "note" = "tape [tape echo]"