select avg(connects + acd) from ( SELECT da.connects as connects, sum(ad.acd) as acd FROM dialeragent da, agentDaily ad WHERE da.employeeID = ? AND da.employeeID = ad.employeeID AND da.dateWorked = ? AND ad.dateWorked = ? group by connects )
On Thu, Mar 10, 2011 at 2:20 PM, Greg Morphis <gmorp...@gmail.com> wrote: > So you want : (13 + 192) / 2? > Or do you need 192/13 ? > > > On Thu, Mar 10, 2011 at 2:07 PM, Torrent Girl <moniqueb...@gmail.com>wrote: > >> >> >can you provide a couple rows of data with no functions? just the ad.acd >> and >> >the da.connects? >> >and what you would like for it to show? whenever you use an aggregate >> >function like avg you have to use group by >> >like >> > >> >select studentId, avg(grade) >> >from grades >> >group by studentId >> > >> > >> > >> >On Thu, Mar 10, 2011 at 1:52 PM, Torrent Girl <moniqueb...@gmail.com> >> wrote: >> > >> >> >> Do you mean let you see the returned data? >> >> Here is my query (there is a group by) :) >> >> SELECT da.connects, sum(ad.acd) as acd FROM dialeragent da, agentDaily ad >> WHERE da.employeeID = ? AND da.employeeID = ad.employeeID AND da.dateWorked >> = ? AND ad.dateWorked = ? group by connects >> >> here is what it returns. >> >> ACD CONNECTS >> 13 192 >> >> I need to total the AVG of these two numbers. >> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342909 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm