Duda con dos Select

[orphen1981]

Perdonadme he metido una variante de la select incial para otra cosa, esta es la buena:

SELECT s.id_address, count(s.id_address) cont
FROM gccom_supply s
JOIN gccom_address a
ON s.id_address = a.id_address
AND a.id_cgh is NOT null
JOIN gccom_sector_supply ss
ON s.id_supply = ss.id_supply
JOIN gccom_contracted_service cs
ON ss.id_sector_supply = cs.id_sector_supply
WHERE cs.status = 'ESTSC00002'
GROUP BY s.id_address
HAVING COUNT(s.id_address) > 1;