CREATE TABLE table_40847 ("Rank" FLOAT, "Name" CLOB, "Years" CLOB, "Matches" FLOAT, "Goals" FLOAT)

What is the average rank for players with under 205 matches and under 100 goals?
SELECT AVG("Rank") FROM table_40847 WHERE "Matches" < '205' AND "Goals" < '100'
SELECT AVG("Rank") FROM "table_40847" WHERE "Goals" < '100' AND "Matches" < '205'