Consulta con Right outher

[Andres95]

Código:

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