sql counting based upon multiple values in other column - sql server management studio

Vote count:

0

I have a table like below. I want to have distinct count of values in column usr for which pn is 2 as well as 3. In below case it will be 2 as usr =1 and usr =3 have values 2 and 3 in column pn. I wont be considering usr=2 becuase id doesnt have pn=3. How could i do that?

usr pn
1   1
1   2
1   3
2   5
2   2
2   8
3   2
3   3

asked 1 min ago

user2543622

117

sql counting based upon multiple values in other column - sql server management studio