CREATE TABLE table_name_81 (name VARCHAR, moving_to VARCHAR, type VARCHAR, nat VARCHAR)

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_name_81 WHERE type = "end of contract" AND nat = "sco" AND moving_to = "cardiff city"
SELECT "name" FROM "table_name_81" WHERE "cardiff city" = "moving_to" AND "end of contract" = "type" AND "nat" = "sco"