Table 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