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

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
;

fork query

edited jul 8 20

created jul 8 20 anonymous