grouping like names

Hi,

I would like to get a count of the number SV's that are serious or service affecting and count those together and then count the SV of annoying seperately.

How would I do that.

Start of the sql is below - along with the output from the query.

If query is working right I would expect to get a count of

11 serious or service affecting
and 4 annoying

set pagesize 10000
set newpage 2
set escape on
set linesize 1000
spool get_low_sev_open_prs.lst
select CM, SV, ST, rg
from SQA."PRDATA"
where
SQA."PRDATA".TY Like 'fault'
and
SQA."PRDATA".PROD = 'emx2500'
and SQA.PRDATA.CO Is Not Null and
SQA.PRDATA.CO Not Like '%Motorola%'

and (( SQA."PRDATA".RG Not Like '%insufficient inf%')
and (SQA."PRDATA".RG Not Like '%misunderst%')
and (SQA."PRDATA".RG Not Like '%dup%')
and (SQA."PRDATA".RG Not Like '%non-reproducible%')
and (SQA."PRDATA".RG Not Like '%not approved%') )

CM                             SV
ST                             RG


------------------------------


--------------------------------------------------


------------------------------


--------------------------------------------------


lopment,  IM                   service affecting
cleared                        implement
fom farem                      annoying
closed                         implement
entation                       service affecting
cleared                        implement
tform tware2                   service affecting
cleared                        implement
log,                           serious
cleared                        implement
Land                           annoying
closed                         implement
rk W Devopment                 cosmetic
closed                         implement
R nd MOL, Cork                 annoying
cleared                        implement
Cl Poc, Lnd                    serious
cleared                        implement
W Land MOL, Cork               serious
closed                         implement
ll oc, nd                      serious
cleared                        implement
pment,  IM                     serious
cleared                        implement
orm S,om                       serious
closed                         implement
opment,  SIM                   serious
closed                         implement
tfom fwre,                     annoying
cr_ready                       implement
lpet,  I                       serious

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own