SELECT ph.UserId AS [User Link], COUNT(ph.UserId) AS Pro...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Selects all user IDs who have ever protected questions and counts how many questions they have protected

Interpersonal Skills

Q&A for people looking to improve their interpersonal communication skills

--Selects all user IDs who have ever protected questions and counts how many questions they have protected

SELECT ph.UserId AS [User Link], COUNT(ph.UserId) AS Protect_by_user
  FROM PostHistory ph
  WHERE ph.PostHistoryTypeId = 19
Group by ph.UserId
;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results