WITH CTE AS(
    SELECT *, cc = COUNT(*) OVER(PARTITION BY User_Name) FROM Table
)
SELECT *
FROM CTE
WHERE
    Work_Role = 'users'
    AND User_Name = 'Oran'
    AND cc > 2
UNION ALL
SELECT *
FROM TABLE
WHERE
   Work_Role = 'admin'
   AND User_Name = 'Oran'

WITH CTE AS(
    SELECT *, cc = COUNT(*) OVER(PARTITION BY User_Name) FROM Table
)
SELECT *
FROM CTE
WHERE
    Work_Role = 'users'
    AND User_Name = 'Oran'
    AND cc > 2
UNION ALL
SELECT *
FROM TABLE
WHERE
   Work_Role = 'admin'
   AND User_Name = 'Oran'

WITH CTE AS(
    SELECT *, cc = COUNT(*) OVER(PARTITION BY User_Name) FROM Table
)
SELECT *
FROM CTE
WHERE
    Work_Role = 'users'
    AND User_Name = 'Oran'
    AND cc > 2
UNION ALL
SELECT *
FROM TABLE
WHERE
   Work_Role = 'admin'
   AND User_Name = 'Oran'