sql = "SELECT C.camera, COUNT(G.*) AS NumeroGuasti FROM camere C LEFT JOIN guasti G ON C.camera = G.camera_g GROUP BY C.camera"
sql = "SELECT C.camera, COUNT(G.*) AS NumeroGuasti FROM camere C LEFT JOIN guasti G ON C.camera = G.camera_g GROUP BY C.camera"