SQLite error "no such column": usually missing quotes, plus 4 other causes

You want the visitors who went into the room called Vault, so you write: SELECT name FROM visitors WHERE room = Vault; and SQLite answers: Error: no such column: Vault But Vault isn't supposed to be