CREATE TABLE table_31683 ("Rank" FLOAT, "Name" CLOB, "Confederation" CLOB, "Caps" FLOAT, "Last" FLOAT)

Who had a rank more than 48, and a last in 2005?
SELECT "Name" FROM table_31683 WHERE "Rank" > '48' AND "Last" = '2005'
SELECT "Name" FROM "table_31683" WHERE "Last" = '2005' AND "Rank" > '48'