select commune,ca from ( SELECT distinct on (commune) commune,  sum(ca_sem) as	ca  FROM odk.table_indicateur_2 where id_region ='50124'  group by commune) as test order by ca asc