Table: tallangatta_football_league_stats
Columns: year
seniors
reserves
thirds_under_17_s
fourths_under_14_s

Question: Which seniors have a year before 2007, Fourths (Under 14's) of kiewa-sandy creek, and a Reserve of mitta united?
SQL: SELECT "seniors" FROM tallangatta_football_league_stats WHERE "year" < 2007 AND "fourths_under_14_s" = 'kiewa-sandy creek' AND "reserves" = 'mitta united'

Question: Which seniors have a year after 2005, a Reserve of kiewa-sandy creek, and Fourths (Under 14's) of kiewa-sandy creek?
SQL: SELECT "seniors" FROM tallangatta_football_league_stats WHERE "year" > 2005 AND "reserves" = 'kiewa-sandy creek' AND "fourths_under_14_s" = 'kiewa-sandy creek'

Question: Which Fourths (Under 14's) have Seniors of dederang mt beauty?
SQL: SELECT "fourths_under_14_s" FROM tallangatta_football_league_stats WHERE "seniors" = 'dederang mt beauty'

Question: Which Thirds (Under 17's) have a Reserve of barnawartha?
SQL: SELECT "thirds_under_17_s" FROM tallangatta_football_league_stats WHERE "reserves" = 'barnawartha'

Question: Which Seniors have YEAR before 2006, and Fourths (Under 14's) of kiewa-sandy creek?
SQL: SELECT "seniors" FROM tallangatta_football_league_stats WHERE "year" < 2006 AND "fourths_under_14_s" = 'kiewa-sandy creek'