Table: shetland_islands
Columns: island
location
area_ha
population
height_m

Question: What island has a population over 76, a height over 210, and an area larger than 12068?
SQL: SELECT "island" FROM shetland_islands WHERE "population" > 76 AND "height_m" > 210 AND "area_ha" > 12068

Question: What is the highest population of Trondra Island in the Scalloway Islands?
SQL: SELECT MAX("population") FROM shetland_islands WHERE "location" = 'scalloway islands' AND "island" = 'trondra'