Table: acc_football_2010_2
Columns: team
head_coach
years_at_school
overall_record
record_at_school
acc_record

Question: What is the Record at School of Tom O'Brien's team?
SQL: SELECT "record_at_school" FROM acc_football_2010_2 WHERE "head_coach" = 'Tom O''Brien'

Question: How many values were used to express the years at school of the Maryland team?
SQL: SELECT COUNT("years_at_school") FROM acc_football_2010_2 WHERE "team" = 'Maryland'

Question: What is the record in the atlantic coast conference for the Miami team?
SQL: SELECT "acc_record" FROM acc_football_2010_2 WHERE "team" = 'Miami'

Question: How many values reflect the overall record of the team coached by Frank Beamer?
SQL: SELECT COUNT("overall_record") FROM acc_football_2010_2 WHERE "head_coach" = 'Frank Beamer'