DontWantFuse

WITH PoolOfUsers
AS (
    SELECT DISTINCT UserID AS U_ID
    FROM dbo.EquipmentMovement
    WHERE  ClientVersion IN ('0.0.105', '0.0.108')
    AND UserID NOT IN (SELECT DISTINCT UserID  FROM dbo.EquipmentMovement WHERE TriggerSourceId = 'Fuse' )
)

, WantNotFuse
AS (
    SELECT UserID, HeroSlotCategoryId, EquipmentId
    , Count(*) AS Amount
    FROM dbo.EquipmentMovement AS EM INNER JOIN PoolOfUsers AS pou ON pou.U_ID = em.UserId
   -- WHERE TriggerSourceId = 'Fuse'
    GROUP BY UserID, HeroSlotCategoryId, EquipmentId
    HAVING Count(*) >= 3
)

SELECT Count (Distinct UserId) FROM WantNotFuse

--SELEcT TOP (100) * FROM WantNotFuse