CREATE VIEW dbo.[S1IMMOBILIARE]
AS
SELECT     SUM(VALORE_STIMATO) AS controvalore, RETE
FROM         C6Mart.PATRIMONIO_IMMOBILIARE
GROUP BY RETE