supervisor talktime holdtime callshandle agent1 400 20 5 agent1 360 30 2 agent1 200 21 5 agent2 150 15 4 agent2 120 10 5 i need add talktime per agent. agent1 = 960 & agent2 = 270 on oracle bi sql how add talktime per agent display in new field. have 250 agents on table. have followig formula too: aht = (talktime + holdtime)/callshandle
this simple group statement. covered in every introduction sql course or book
select supervisor, sum(talktime+holdtime) / sum(callshandle) aht yourtable group supervisor 