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

What is the transfer fee for rory loy?
SELECT "Transfer fee" FROM table_50075 WHERE "Name" = 'rory loy'
SELECT "Transfer fee" FROM "table_50075" WHERE "Name" = 'rory loy'