user: Question: Name the position in table for 1 July 2008 when manner of departure is Resigned
Columns: ['Team', 'Outgoing manager', 'Manner of departure', 'Date of vacancy', 'Replaced by', 'Date of appointment', 'Position in table']
Types: ['text', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['AaB', 'Erik Hamrén', 'End of contract', '30 June 2008', 'Bruce Rioch', '1 July 2008', 'Pre-season']
SQL:

assistant: SELECT "Position in table" FROM "Table" WHERE "Date of appointment" = '1 July 2008' AND "Manner of departure" = 'Resigned';