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?
SQL: SELECT MAX(average) FROM table_name_87 WHERE highest = 5 OFFSET 078