Table: brewery_awards
Columns: year
beer_name
prize
category
competition

Question: What year did maggs magnificent mild bear win overall at the camra reading branch beer festival?
SQL: SELECT MAX("year") FROM brewery_awards WHERE "beer_name" = 'maggs magnificent mild' AND "competition" = 'camra reading branch beer festival' AND "category" = 'overall'

Question: What prize did good old boy win in 2002 at the camra london and south east regional competition?
SQL: SELECT "prize" FROM brewery_awards WHERE "year" > 2002 AND "competition" = 'camra london and south east regional competition' AND "beer_name" = 'good old boy'

Question: What year did maggs magnificent mild win a gold medal in the mild and porter category at the siba south east region beer competition?
SQL: SELECT AVG("year") FROM brewery_awards WHERE "beer_name" = 'maggs magnificent mild' AND "prize" = 'gold medal' AND "category" = 'mild and porter' AND "competition" = 'siba south east region beer competition'

Question: What beer won a silver medal at the camra reading branch beer festival in 2008?
SQL: SELECT "beer_name" FROM brewery_awards WHERE "prize" = 'silver medal' AND "competition" = 'camra reading branch beer festival' AND "year" = 2008