Select ΠΟΛΗ, count(ΚΩΔ_ΠΕΛΑΤΗ)as TOTAL

From ΠΕΛΑΤΕΣ          

Group by ΠΟΛΗ

Having TOTAL >1000