OPEN DATABASE "db";

SELECT salesarea, SUM(turnover__1)
FROM customers
WHERE salesarea BETWEEN "0" AND "9"
GROUP BY salesarea
HAVING SUM(turnover__1) > 100000;
