SELECT telefonico.sucursal,sucursal.nombre,COUNT(*) AS total, AVG(telefonico.total) AS media
FROM telefonico
INNER JOIN sucursal ON telefonico.sucursal = sucursal.nombre
WHERE (telefonico.region = '1') AND (telefonico.fcaptura BETWEEN CONVERT(DATETIME, '2007-08-01 00:00:00', 102) AND CONVERT(DATETIME,
'2007-08-31 00:00:00', 102))
ORDER BY 1,2