aggregate functions in "SELECT" - Mailing list pgsql-novice

Dear Colleagues,

How can I use the COUNT variable and the COL_YES variable to calculate a
percentage COL_YES/COUNT*100?

This operation isn't allowed in the "SELECT" statement.

Thanks


Select  g.STATE,
     g.COMPANY,
     g.MODEL,
        count(g.MODEL) as COUNT,
        coalesce(sum(case when COLORS = 'Yes' then 1 else 0 end),0) as
COL_YES
from gentech_12_13 as g
where MODEL = '0387' and COMPANY = 'ACME'
group by g.STATE, g.COMPANY, g.MODEL
;

--
siamo arrivati sani e salvi