Table: brewers_pitchers
Columns: pitcher
stats
wins
losses
no_decisions
winning
seasons

Question: What are Doug Davis' maximum pitching stats?
SQL: SELECT MAX("stats") FROM brewers_pitchers WHERE "pitcher" = 'Doug Davis'

Question: List the pitchers for the 1970 season
SQL: SELECT "pitcher" FROM brewers_pitchers WHERE "seasons" = '1970'

Question: How many wins had a win percentage of 0.667
SQL: SELECT "wins" FROM brewers_pitchers WHERE "winning" = '0.667'

Question: how many "no decisions" are there with 3 wins and a win percentage of 1.000?
SQL: SELECT MIN("no_decisions") FROM brewers_pitchers WHERE "winning" = '1.000' AND "wins" = 3