user: ### NOW ANSWER:
Question: What is the date of appointment for the team with a Resigned manner of departure and replaced by Sandy Clark?
Columns: ['Team', 'Outgoing manager', 'Manner of departure', 'Date of vacancy', 'Replaced by', 'Date of appointment']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['Rangers', 'Walter Smith', 'Resigned', 'May 1998', 'Dick Advocaat', 'June 1998']
SQL:

assistant: SELECT "Date of appointment" FROM "Table" WHERE "Manner of departure" = 'Resigned' AND "Replaced by" = 'Sandy Clark';