Table: mll_season_stats
Columns: month
week
offensive
defensive
goalkeeper
rookie

Question: Who is the rookie goalkeeper Rob Scherr who played before week 6?
SQL: SELECT "rookie" FROM mll_season_stats WHERE "goalkeeper" = 'rob scherr' AND "week" < 6

Question: Who is the rookie goalkeeper Mike Gabel?
SQL: SELECT "rookie" FROM mll_season_stats WHERE "goalkeeper" = 'mike gabel'

Question: What was the lowest week in the month of August against Andrew Combs?
SQL: SELECT MIN("week") FROM mll_season_stats WHERE "month" = 'august' AND "offensive" = 'andrew combs'

Question: Who was the rookie that played week 6?
SQL: SELECT "rookie" FROM mll_season_stats WHERE "week" = 6