user: ### NOW ANSWER:
Question: What is the highest population of Trondra Island in the Scalloway Islands?
Columns: ['Island', 'Location', 'Area ( ha )', 'Population', 'Height (m)']
Types: ['text', 'text', 'real', 'real', 'real']
Sample row: ['Balta', 'North Isles', 80.0, 0.0, 44.0]
SQL:

assistant: SELECT MAX("Population") FROM "Table" WHERE "Location" = 'Scalloway Islands' AND "Island" = 'Trondra';