1

Please login or register to vote for this query.

(click on this box to dismiss)

My upvotes

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

-- Enter Query Title
-- Enter Query Description

DECLARE @UserId int = ##userId##

SELECt v.CreationDate, COUNT(v.Id)*15
FROM Votes v
JOIN VoteTypes vt ON vt.Id = v.VoteTypeId
JOIN Posts p ON p.Id = v.PostId
WHERE p.OwnerUserId = @UserId
AND vt.Name IN('UpMod')
GROUP BY v.CreationDate
HAVING COUNT(v.Id)*15 >= 200

fork query

created aug 19 11 jon.doe6502