0

Please login or register to vote for this query.

(click on this box to dismiss)

Counts how many edits to go before a person hits Strunk & White Edit the ID number to get your value

Q&A about the site for linguists, teachers and students of the Ukrainian language

-- How Many Edits Until Strunk & White
-- Counts how many edits to go before a person hits Strunk & White
-- Edit the ID number to get your value

DECLARE @UserId int = ##UserId##

SELECT 100 - COUNT(*) AS 'Edits To Strunk & White' FROM Posts
WHERE (PostTypeId = 1 OR PostTypeId = 2)
AND   LastEditorUserId = @UserId

fork query

created feb 17 11 anonymous