user: ### NOW ANSWER:
Question: What is the average map reference number for Lake Michigan, a larger rank than 15, and a smaller population on 2007 than 114504
Columns: ['Rank', 'Map Reference Number', 'Census Statistical Area', '2007 Population', 'Lake(s)']
Types: ['real', 'real', 'text', 'real', 'text']
Sample row: [1.0, 16.0, 'Chicago-Naperville-Michigan City, IL-IN-WI CSA', 9745165.0, 'Lake Michigan']
SQL:

assistant: SELECT AVG("Map Reference Number") FROM "Table" WHERE "Lake(s)" = 'Lake Michigan' AND "Rank" > 15.0 AND "2007 Population" < 114504.0;