Exercicio 2 SQL

ex2.sql

WITH bichos_familia AS(
SELECT m.id_familia, SUM(m.quantidadebichosestimacao) AS bichos FROM Morador m
GROUP BY m.id_familia
)

SELECT c.bairro AS 'Bairro', COALESCE(SUM(b.bichos),0) AS 'Bichos de Estimação' FROM Condominio c
LEFT JOIN Familia f ON c.Id = f.id_condominio
LEFT JOIN bichos_familia b ON b.id_familia = f.id
GROUP BY c.bairro