user: ### NOW ANSWER:
Question: What is the sum of the lowest in attendance when the average is 1166 and most in attendance is less than 2215?
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 SUM("Lowest") FROM "Table" WHERE "Average" = 1166.0 AND "Highest" < 2215.0;