user: ### NOW ANSWER:
Question: What was the date of appointment for the manager of Lecce when the previous manager's Contract expired?
Columns: ['Team', 'Outgoing manager', 'Manner of departure', 'Date of vacancy', 'Replaced by', 'Date of appointment']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['Siena', 'Mario Beretta', 'Contract expired', '27 May 2008', 'Marco Giampaolo', '27 May 2008']
SQL:

assistant: SELECT "Date of appointment" FROM "Table" WHERE "Manner of departure" = 'Contract expired' AND "Team" = 'Lecce';