Ver originalSELECT Sector, COUNT(*) todos, SUM(IF(limiteagua > 1,1,0)) abiertos FROM contador GROUP BY sector