Table: maria_josepha_1765_duchess
Columns: name
birth
marriage
became_duchess
ceased_to_be_duchess
death
spouse

Question: Which member of house of Habsburg-Lorraine had the spouse Charles II?
SQL: SELECT "name" FROM maria_josepha_1765_duchess WHERE "spouse" = 'charles ii'

Question: What is the marriage date for the Habsburg-Lorraine house member who died 29 December 1829?
SQL: SELECT "marriage" FROM maria_josepha_1765_duchess WHERE "death" = '29 december 1829'

Question: When did the duchess who became duchess on 7/8 April 1766 cease to be duchess?
SQL: SELECT "ceased_to_be_duchess" FROM maria_josepha_1765_duchess WHERE "became_duchess" = '7/8 april 1766'

Question: What is the date of death of the duchess born on 30 October 1797?
SQL: SELECT "death" FROM maria_josepha_1765_duchess WHERE "birth" = '30 october 1797'

Question: What is the birth date of the duchess who married on 1 May 1844?
SQL: SELECT "birth" FROM maria_josepha_1765_duchess WHERE "marriage" = '1 may 1844'