user: ### NOW ANSWER:
Question: What is the highest average number in attendance when the most in attendance is 5078?
Columns: ['Team', 'Stadium', 'Capacity', 'Highest', 'Lowest', 'Average']
Types: ['text', 'text', 'real', 'real', 'real', 'real']
Sample row: ['Dundee', 'Dens Park', 11856.0, 6192.0, 3146.0, 4264.0]
SQL:

assistant: SELECT MAX("Average") FROM "Table" WHERE "Highest" = 5078.0;