I was wondering if there was a way to alter the below query to show the overall results
x
SELECT STATUS ,count( * )
FROM vicidial_list
WHERE list_id
BETWEEN 2732900 AND 2732905
GROUP BY 1
ORDER BY 1
This is what it currently shows
STATUS count( * )
A 32
AA 1386
ADC 57
B 21
DNC 50
DROP 70
LR 21
N 36
NA 319
NC 38
NL 7
PDROP 6
R 45
RD 1136
RO 506
SALE 102
TP 3
WN 6
Is there a way to alter the query to show the sum of just the A, AA, B, Drop, N, NA, NC, and PDROP so when I run the query it will just give me all these status codes added up?
What I would like to show
STATUS count( * )
A 32
AA 1386
B 21
DROP 70
N 36
NA 319
NC 38
PDROP 6
Total = 1908 The overall sum of these status codes are most important
Advertisement
Answer
something like this :
SELECT status
,count(*) counts
FROM vicidial_list
WHERE list_id BETWEEN 2732900 AND 2732905
and status in ('A', 'AA', 'B', 'Drop', 'N', 'NA', 'NC', 'PDROP')
GROUP BY status with rollup
ORDER BY 1
db<>fiddle here