CREATE TABLE table_49621 ("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. 6 of the person with a No. 10 of Joshua and a No. 8 of Andrew?
SELECT "No. 6" FROM table_49621 WHERE "No. 10" = 'joshua' AND "No. 8" = 'andrew'
SELECT "No. 6" FROM "table_49621" WHERE "No. 10" = 'joshua' AND "No. 8" = 'andrew'