CREATE TABLE table_name_56 (no_6 VARCHAR2, no_10 VARCHAR2, no_8 VARCHAR2)

What is the No. 6 of the person with a No. 10 of Joshua and a No. 8 of Andrew?
SELECT no_6 FROM table_name_56 WHERE no_10 = "joshua" AND no_8 = "andrew"
SELECT "no_6" FROM "table_name_56" WHERE "andrew" = "no_8" AND "joshua" = "no_10"