Query SELECT ROUND(AVG(total),2) AS totales FROM ( SELECT vendedor, SUM(importe) AS total FROM empresa.ventas GROUP BY vendedor HAVING vendedor IS NOT NULL) AS totales, Sun Nov 23 12:09:45 2008