How to calculate the average of a query result mysql? [duplicate]

0

How do I get the field "count (t2.id_atend) TOTAL_ATENDIMENTO "and calculate the mean of it in PHP?

SELECT t3.desc_serv, 
    t3.nm_serv,
    t1.nm_usu,
    count(t2.id_atend) TOTAL_ATENDIMENTO
FROM usuarios t1
INNER JOIN historico_atendimentos t2 ON t1.id_usu = t2.id_usu
INNER JOIN servicos t3 ON t2.id_serv = t3.id_serv
WHERE t3.id_serv = 9 AND t2.dt_fim LIKE '%2013-10%'
GROUP BY t3.id_serv, t1.id_usu

output print:

    
asked by anonymous 30.04.2014 / 18:07

1 answer

2
select avg(TOTAL_ATENDIMENTO) MEDIA_TOTAL_ATENDIMENTO
from
(
SELECT t3.desc_serv, 
    t3.nm_serv,
    t1.nm_usu,
    count(t2.id_atend) TOTAL_ATENDIMENTO
FROM usuarios t1
INNER JOIN historico_atendimentos t2 ON t1.id_usu = t2.id_usu
INNER JOIN servicos t3 ON t2.id_serv = t3.id_serv
WHERE t3.id_serv = 9 AND t2.dt_fim LIKE '%2013-10%'
GROUP BY t3.id_serv, t1.id_usu
) virtual
    
30.04.2014 / 18:38