Table: michigan_basketball_scandal
Columns: season
coach
record_as_played
actual_adjusted_record
regular_season_vacated

Question: Who, was the coach with an actual adjusted record of 0–19?
SQL: SELECT "coach" FROM michigan_basketball_scandal WHERE "actual_adjusted_record" = '0–19'

Question: What is the average Season for coach Fisher, and an actual adjusted record of 0–11?
SQL: SELECT AVG("season") FROM michigan_basketball_scandal WHERE "coach" = 'fisher' AND "actual_adjusted_record" = '0–11'

Question: What is the regular season vacated for the Record as played of 12–19?
SQL: SELECT "regular_season_vacated" FROM michigan_basketball_scandal WHERE "record_as_played" = '12–19'

Question: How many seasons did coach steve fisher have?
SQL: SELECT COUNT("season") FROM michigan_basketball_scandal WHERE "coach" = 'steve fisher'

Question: What is shown for Record as played with a Regular season Vacated of 24–0 later than 1997?
SQL: SELECT "record_as_played" FROM michigan_basketball_scandal WHERE "regular_season_vacated" = '24–0' AND "season" > 1997

Question: How many seasons have an Actual adjusted record of 0–19?
SQL: SELECT COUNT("season") FROM michigan_basketball_scandal WHERE "actual_adjusted_record" = '0–19'