CREATE TABLE table_name_4 (developer_s_ VARCHAR2, game VARCHAR2)

Who was the developer of Resident Evil 4?
SELECT developer_s_ FROM table_name_4 WHERE game = "resident evil 4"
SELECT "developer_s_" FROM "table_name_4" WHERE "game" = "resident evil 4"