CREATE TABLE table_6631 ("Name" CLOB, "Country" CLOB, "Type" CLOB, "Moving from" CLOB, "Transfer window" CLOB, "Ends" CLOB, "Transfer fee" CLOB, "Source" CLOB)

What ends has transferred as the type?
SELECT "Ends" FROM table_6631 WHERE "Type" = 'transferred'
SELECT "Ends" FROM "table_6631" WHERE "Type" = 'transferred'