how to use aggregate functions in this case

From: "Janek Sendrowski" <janek12(at)web(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: how to use aggregate functions in this case
Date: 2013-08-25 21:59:03
Message-ID: trinity-787472a4-53b7-4fff-9d01-69a266e6aa61-1377467943440@3capp-webde-bs31
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Thats my code snipped:
 
SELECT  v_rec1.user,
       sum(CASE WHEN v_rec_fts.lev BETWEEN 0 AND 25 THEN 1 ELSE 0 END) as "0 to 25",
        sum(CASE WHEN v_rec_fts.lev BETWEEN 25 AND 50 THEN 1 ELSE 0 END) as "25 to 50",
sum(CASE WHEN v_rec_fts.lev BETWEEN 50 AND 100 THEN 1 ELSE 0 END) as "50 to 100"
        INTO v_rec2
        GROUP BY user;

Now I want to summuarize the "0 to 25" values and the others in the same query.
Somehow like this: count("0 to 25")
But I want to do it with every single user and I don't know how to do that

A result should look like this:

user percentage count
smith "0 to 25" 5
smith "25 to 50" 7
smith "50 to 75" 2
jones "0 to 25" 11
jones "25 to 50" 1
jones "50 to 75" 3

Hope someone who can help me

Janek Sendrowski

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2013-08-25 22:10:32 Re: how to use aggregate functions in this case
Previous Message Adrian Klaver 2013-08-25 01:04:17 Re: batch insertion