Select
ΠΟΛΗ
,
count
(
ΚΩΔ
_
ΠΕΛΑΤΗ
)
as
TOTAL
From
ΠΕΛΑΤΕΣ
Group
by
ΠΟΛΗ
Having TOTAL
>1000