At Balmoor Stadium, what's the total average having a greater than 400 lowest?
CREATE TABLE table_name_77 (average VARCHAR, stadium VARCHAR, lowest VARCHAR)
SELECT COUNT(average) FROM table_name_77 WHERE stadium = "balmoor" AND lowest > 400
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_77 (average VARCHAR, stadium VARCHAR, lowest VARCHAR) Question: At Balmoor Stadium, what's the total average having a greater than 400 lowest? [/INST] SELECT COUNT(average) FROM table_name_77 WHERE stadium = "balmoor" AND lowest > 400 </s>