PIOGGIA CUMULATA: SELECT sum(T.maxrain) as totrain FROM ((select MAX(CAST(rain AS DECIMAL(5,2))) AS maxrain, data from DatiStazioniDrop where IdStazione=35 AND  data BETWEEN '2024-04-01' AND '2024-04-30' GROUP BY data) AS T); <br/>PIOGGIA CUMULATA: SELECT sum(T.maxrain) as totrain FROM ((select MAX(CAST(rain AS DECIMAL(5,2))) AS maxrain, data from DatiStazioniDrop where IdStazione=35 AND  data BETWEEN '2024-01-01' AND '2024-12-31' GROUP BY data)AS T); <br/><h3>RIEPILOGHI MENSILI E ANNUALI DA FARE</h3><h3>RIEPILOGHI MENSILI</h3>ESEGUO: INSERT INTO dropediacurrentmonthriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax,
		DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (35,'','','','','','','','','','','','',''); <br/><h3>RIEPILOGHI ANNUALI</h3>ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax,
		DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (35,'','','','','','','','','','','','',''); <br/>