CREATE TABLE table_14999 ("No.1" TEXT, "No.2" TEXT, "No.3" TEXT, "No.4" TEXT, "No.5" TEXT, "No.6" TEXT, "No.7" TEXT, "No.8" TEXT, "No.9" TEXT, "No.10" TEXT, "FINAL" TEXT)

Who was number 9 that had a number 7 of Joana and a Final of Pedro?
SELECT "No.9" FROM table_14999 WHERE "No.7" = 'joana' AND "FINAL" = 'pedro'
SELECT "No.9" FROM "table_14999" WHERE "FINAL" = 'pedro' AND "No.7" = 'joana'