UPDATE DBAINTERVENTION.EMPLOYE
 /*  augmente les salaires  */
SET SALAIREPLOYE = SALAIREPLOYE + 100
WHERE NUMEMPLOYE
    IN(SELECT NUMEMPLOYE FROM(
      SELECT COUNT(*) AS num,NUMEMPLOYE
        FROM DBAINTERVENTION.INTERVENANTS
        GROUP BY NUMEMPLOYE
        )
  WHERE num>5)
;