How many values reflect the overall record of the team coached by Frank Beamer?
CREATE TABLE table_28744929_2 (overall_record VARCHAR, head_coach VARCHAR)
SELECT COUNT(overall_record) FROM table_28744929_2 WHERE head_coach = "Frank Beamer"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_28744929_2 (overall_record VARCHAR, head_coach VARCHAR) Question: How many values reflect the overall record of the team coached by Frank Beamer? [/INST] SELECT COUNT(overall_record) FROM table_28744929_2 WHERE head_coach = "Frank Beamer" </s>