What is the highest average number in attendance when the most in attendance is 5,078?
CREATE TABLE table_name_87 (average INTEGER, highest VARCHAR)
SELECT MAX(average) FROM table_name_87 WHERE highest = 5 OFFSET 078 ROWS
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_87 (average INTEGER, highest VARCHAR) Question: What is the highest average number in attendance when the most in attendance is 5,078? [/INST] SELECT MAX(average) FROM table_name_87 WHERE highest = 5 OFFSET 078 ROWS </s>