Q&A for students, teachers, and linguists wanting to discuss the finer points of the Japanese language
SELECT TOP 100 DATEADD(day, DATEDIFF(day, 0,v.CreationDate), 0), CASE WHEN SUM(CASE WHEN v.VoteTypeId = 2 THEN 10 WHEN v.VoteTypeId = 3 THEN -2 ELSE NULL END) > 200 THEN 200 ELSE SUM(CASE WHEN v.VoteTypeId = 2 THEN 10 WHEN v.VoteTypeId = 3 THEN -2 ELSE NULL END) END FROM Users u JOIN Posts p ON p.OwnerUserId = u.Id JOIN Votes v ON v.PostId = p.Id --JOIN SuggestedEdits e ON e.OnwerUserId = u.Id WHERE u.Id = 9190135 GROUP BY DATEADD(day, DATEDIFF(day, 0,v.CreationDate), 0)