MySQL

sql count total calls

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jun 2008

Posts: 40

Reputation: enim213 is an unknown quantity at this point

Solved Threads: 2

enim213

Offline

Light Poster

sql count total calls

Nov 19th, 2008

hi guys! i am enim, i usually post thread in PHP and i guess its my first time here in mysql..

i have problem regarding the total count of the terminatecause..
i need the count of ANSWERED calls only and the total count of all calls..
can i do this in one query.. because my query below isn't working..

pls. help

thanx
enim

 Help with Code Tags 
 mysql Syntax (Toggle Plain Text) 
SELECT destination, count(terminatecause) as tc							CASE terminatecause 
								WHEN 'ANSWER' THEN count(terminatecause)
								END as allcall
							FROM tblTable1
							JOIN tblTable2on tblTable1.someID = tblTable2.someID
							JOIN tblTable3on tblTable2.someID1 = tblTable3.someID1
							WHERE tblTable3.someID1= '1'
							AND tblTable1.someUser= 'user'
							AND tblTable1.callstarttime BETWEEN '2008-08-01 00:00:00' AND '2008-08-01 23:00:00'
							GROUP BY destination, terminatecause ORDER BY destination asc
select destination, count(terminatecause) as tc							CASE terminatecause 
								when 'ANSWER' then count(terminatecause)
								end as allcall
							from tblTable1
							join tblTable2on tblTable1.someID = tblTable2.someID
							join tblTable3on tblTable2.someID1 = tblTable3.someID1
							where tblTable3.someID1= '1'
							and tblTable1.someUser= 'user'
							and tblTable1.callstarttime between '2008-08-01 00:00:00' and '2008-08-01 23:00:00'
							group by destination, terminatecause order by destination asc