user: Question: What was the date of appointment for incoming manager Roy Hodgson and the team is Liverpool?
Columns: ['Team', 'Outgoing manager', 'Manner of departure', 'Date of vacancy', 'Table', 'Incoming manager', 'Date of appointment']
Types: ['text', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['West Ham United', 'Gianfranco Zola', 'Contract terminated', '11 May 2010', 'Pre-season', 'Avram Grant', '3 June 2010']
SQL:

assistant: SELECT "Date of appointment" FROM "Table" WHERE "Team" = 'Liverpool' AND "Incoming manager" = 'Roy Hodgson';