CREATE TABLE table_58971 ("Nat." CLOB, "Name" CLOB, "Moving to" CLOB, "Type" CLOB, "Transfer window" CLOB)

Who is moving to Chelsea on loan?
SELECT "Name" FROM table_58971 WHERE "Type" = 'loan' AND "Moving to" = 'chelsea'
SELECT "Name" FROM "table_58971" WHERE "Moving to" = 'chelsea' AND "Type" = 'loan'