List:General Discussion« Previous MessageNext Message »
From:Kelly W [PCS] Black Date:October 31 2002 6:42pm
Subject:sql query
View as plain text  
Hi,

I could use some advice on this query.

SELECT cell, sum(att) as att , sum(lc) as lc , sum(csh) as csh, 
ROUND((SUM( lc + csh ) * 100 ) / (SUM(att) - SUM(tccf + bpp + bpc + suf)),2)

AS drops, sum(tccf) as tccf, sum(bpp) as bpp, sum(bpc) as bpc, sum(suf) as
suf, 
ROUND((SUM( tccf + bpp + bpc + suf) *100 ),2) / ROUND(SUM(att),2)
AS blocks, sum(mou) as mou, release FROM ss WHERE release=CURDATE()
AND (( cell=2 and sector=1) OR (cell=3 and sector=1))
GROUP BY cell ORDER BY hour;

It works fine. But I cannot figure out how to add the results together where

cell2 and cell3 are tallied together on one line. Any help with changing the
query
would be appreciated.

Thanks as ever!

Regards,

Kelly Black

Linux was very clearly the answer, but what was the question again?

Thread
sql queryKelly W [PCS] Black31 Oct