Table: sowetoderby
Columns: season
division
date
home_team
result
away_team

Question: Which season had a result of 1–0 (aet)?
SQL: SELECT "season" FROM sowetoderby WHERE "result" = '1–0 (aet)'

Question: What is the date in the 2007-08 season where the away team was the kaizer chiefs?
SQL: SELECT "date" FROM sowetoderby WHERE "season" = '2007-08' AND "away_team" = 'Kaizer Chiefs'

Question: How many dates are shown for the home team of orlando pirates and result of 1–3?
SQL: SELECT COUNT("date") FROM sowetoderby WHERE "home_team" = 'Orlando Pirates' AND "result" = '1–3'

Question: What is the division where the result was 0–2?
SQL: SELECT "division" FROM sowetoderby WHERE "result" = '0–2'

Question: What is the date where the home team was kaizer chiefs and the division was mtn 8 semi-final?
SQL: SELECT "date" FROM sowetoderby WHERE "home_team" = 'Kaizer Chiefs' AND "division" = 'MTN 8 Semi-final'