select ΚΩΔΠΕΛ, count(ΚΩΔΠΑΡ)as PLHTHOS

from ΠΑΡΑΓΓΕΛΙΕΣ

group by ΚΩΔΠΕΛ

having PLHTHOS >10