CREATE TABLE table_name_45 (no_10 VARCHAR, no_1 VARCHAR, no_9 VARCHAR)

What is No. 10, when No. 1 is Noah, and when No. 9 is Carter?
SELECT no_10 FROM table_name_45 WHERE no_1 = "noah" AND no_9 = "carter"
SELECT "no_10" FROM "table_name_45" WHERE "carter" = "no_9" AND "no_1" = "noah"