text: Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
  ### Context:
  CREATE TABLE table_17039232_3 (position_in_table VARCHAR, date_of_appointment VARCHAR, manner_of_departure VARCHAR)
  ### Question:
  Name the position in table for 1 july 2008 when manner of departure is resigned
  ### Answer:
  SELECT position_in_table FROM table_17039232_3 WHERE date_of_appointment = "1 July 2008" AND manner_of_departure = "Resigned"