user: ### NOW ANSWER:
Question: What district is the parish who had the South Cambridgeshire Rural District as the former local authority?
Columns: ['Name', 'Status', 'Population', 'District', 'Former local authority']
Types: ['text', 'text', 'real', 'text', 'text']
Sample row: ['Cambridge', 'Unparished area', 108863.0, 'Cambridge', 'Cambridge Municipal Borough']
SQL:

assistant: SELECT "District" FROM "Table" WHERE "Former local authority" = 'South Cambridgeshire Rural District';