SQL sum up count group by

Question

Currently have a query that hits AWS Redshift. I have this group by a recipient in order to count the total of the output.

select count(CASE WHEN event_name = 'c' THEN 1 END) 
from oe
where owner_id = $1
and rid = $2
and cid = $2
and rbid is not null 
group by recipient 
having count(CASE WHEN event_name = 'c' THEN 1 END) > 0
and count(CASE WHEN event_name = 'd' THEN 1 END) > 0

The output from that is this

I'd like to be able, to sum up those numbers to produce a final number, as well as count the number of rows. How can I go about achieving this?

putting whole query into sum will sum up all the resulting numbers and output the final summed number. — Vikas Kandari
– Vikas Kandari, Commented Aug 31, 2020 at 18:33

Atif · Accepted Answer · 2020-08-31 18:39:48Z

1

This should give you the desired result.

select sum(sum_c), count(*) from (
 select count(CASE WHEN event_name = 'c' THEN 1 END) sum_c
from oe
where owner_id = $1
and rid = $2
and cid = $2
and rbid is not null 
group by recipient 
having count(CASE WHEN event_name = 'c' THEN 1 END) > 0
and count(CASE WHEN event_name = 'd' THEN 1 END) > 0) x;

answered Aug 31, 2020 at 18:39

Atif

2,2202 gold badges11 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL sum up count group by

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related