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

What is the name of the person with a type of end of contract, nat of sco, and the Moving to is cardiff city?
SELECT "Name" FROM table_51978 WHERE "Type" = 'end of contract' AND "Nat." = 'sco' AND "Moving to" = 'cardiff city'
SELECT "Name" FROM "table_51978" WHERE "Moving to" = 'cardiff city' AND "Nat." = 'sco' AND "Type" = 'end of contract'