CREATE TABLE table_name_26 (no_1 VARCHAR, no_2 VARCHAR)

What is the No. 1 of the person with a No. 2 of John?
SELECT no_1 FROM table_name_26 WHERE no_2 = "john"
SELECT "no_1" FROM "table_name_26" WHERE "john" = "no_2"