What is the date of appointment for the team with a resigned manner of departure and replaced by Sandy Clark?
SELECT Date of appointment FROM table WHERE Manner of departure = resigned AND Replaced by = sandy clark