user: ### NOW ANSWER:
Question: When  ASV Nürnberg-Süd is the  mittelfranken süd what is the season?
Columns: ['Season', 'Mittelfranken Nord', 'Mittelfranken Süd', 'Unterfranken West', 'Unterfranken Ost', 'Oberfranken West', 'Oberfranken Ost']
Types: ['text', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['1951-52', 'Jahn Forchheim', 'ASV Fürth', 'Viktoria Kahl', 'FC Bad Kissingen', 'VfB Coburg', 'VfB Bayreuth']
SQL:

assistant: SELECT "Season" FROM "Table" WHERE "Mittelfranken Süd" = 'ASV Nürnberg-Süd';