CREATE TABLE table_49620 ("Region  ( year ) " CLOB, "No. 1" CLOB, "No. 2" CLOB, "No. 3" CLOB, "No. 4" CLOB, "No. 5" CLOB, "No. 6" CLOB, "No. 7" CLOB, "No. 8" CLOB, "No. 9" CLOB, "No. 10" CLOB)

What is the No. 1 of the person with a No. 2 of John?
SELECT "No. 1" FROM table_49620 WHERE "No. 2" = 'john'
SELECT "No. 1" FROM "table_49620" WHERE "No. 2" = 'john'