Troubling query

Can you try below

SELECT EmployeeId
FROM EmployeeActivities a
where ActivitiyId = 1571
and EXISTS(select top 1 1 from EmployeeActivities b where a.EmployeeId=b.EmployeeId and b.ActivitiyId= 1625)

Thanks

Saravana Kumar C