CREATE TABLE table_44102 ("Nat." CLOB, "Name" CLOB, "Moving from" CLOB, "Type" CLOB, "Transfer window" CLOB, "Ends" FLOAT, "Transfer fee" CLOB, "Source" CLOB)

Which name has the source apoelfc.com.cy and a type of transfer?
SELECT "Name" FROM table_44102 WHERE "Source" = 'apoelfc.com.cy' AND "Type" = 'transfer'
SELECT "Name" FROM "table_44102" WHERE "Source" = 'apoelfc.com.cy' AND "Type" = 'transfer'