Re: Not able to understand how to write group by

Arup Rakshit wrote
> SELECT users.gender,count(*) as participant,
> case when daily_action_answers.measure_id = 1 then
> avg(daily_action_answers.value) end as cpd,
> case when daily_action_answers.measure_id = 2 then
> avg(daily_action_answers.value) end as other 
> FROM users INNER JOIN daily_action_answers ON daily_action_answers.user_id
> = users.id
> INNER JOIN measures ON measures.id = daily_action_answers.measure_id
> WHERE (((daily_action_answers.day between '2014-07-03' and
> '2014-12-31')and daily_action_answers.daily_action_id = 1)) 
> GROUP BY users.gender, daily_action_answers.measure_id
>
> gender | participant | cpd |other 
>
> "Female", 2 , 8.5, 0.0
> "Female", 1 , 0.0, 8.0
> "None", 2, 6.5, 0.0
> "None", 1, 0.0, 5.0
> "Male", 1, 4.0, 0.0, 
> "Male", 2, 0.0, 10.0
>
> Problem is.. I am not able to merge those pair rows into one... :-(

Without commenting on the rest of it...to combine what you show here just
GROUP BY gender and SUM() everything else (i.e., turn the above into a
subquery and then do this)

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Not-able-to-understand-how-to-write-group-by-tp5810250p5810365.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.