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

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

having PLHTHOS >10

group by ΚΩΔΠΕΛ