CREATE TABLE table_name_40 (rank VARCHAR2, rider VARCHAR2)

What ran has noel patterson as the rider?
SELECT rank FROM table_name_40 WHERE rider = "noel patterson"
SELECT "rank" FROM "table_name_40" WHERE "noel patterson" = "rider"