SELECT C.COD_COLABORADOR, C.NOME FROM COLABORADOR C
WHERE C.COD_COLABORADOR NOT IN (SELECT P.COD_RESPONSAVEL
                                FROM PEDIDO_ASSISTENCIA P)
      AND (SELECT COUNT(*)
           FROM COMP_SOFTWARE CP INNER JOIN SOFTWARE S
           ON (CP.COD_SOFTWARE = S.COD_SOFTWARE)
           WHERE (CP.COD_COLABORADOR = C.COD_COLABORADOR AND S.TIPO=1))
           =
           (SELECT COUNT(*)
           FROM SOFTWARE S1
           WHERE (S1.TIPO=1))
      AND (SELECT COUNT(*)
           FROM COMP_SOFTWARE CP INNER JOIN SOFTWARE S
           ON (CP.COD_SOFTWARE = S.COD_SOFTWARE)
           WHERE (CP.COD_COLABORADOR = C.COD_COLABORADOR AND S.TIPO=2))
           = 1
      AND (SELECT COUNT(*)
           FROM COMP_SOFTWARE CP INNER JOIN SOFTWARE S
           ON (CP.COD_SOFTWARE = S.COD_SOFTWARE)
           WHERE (CP.COD_COLABORADOR = C.COD_COLABORADOR AND S.NOME = 'Windows')) = 1