question: What is the name of the person with a type of end of contract, nat of sco, and the Moving to is cardiff city?
answer: SELECT name FROM table_name_81 WHERE type = "end of contract" AND nat = "sco" AND moving_to = "cardiff city"
context: CREATE TABLE table_name_81 (name VARCHAR, moving_to VARCHAR, type VARCHAR, nat VARCHAR)