instruction: Top answerers in C# in the last year.
response: SELECT answers.Score, u.* FROM (SELECT u.Id AS UserId, SUM(a.Score) AS score FROM Users AS u JOIN Posts AS a ON (a.OwnerUserId = u.Id) JOIN PostTypes AS at ON (at.Id = a.PostTypeId) JOIN Posts AS q ON (q.Id = a.ParentId) JOIN PostTypes AS qt ON (qt.Id = q.PostTypeId) WHERE q.Tags LIKE '%ibm-cloud%' AND qt.Id = 1 AND at.Id = 2 AND a.CreationDate >= DATEADD(YEAR, -1, GETDATE()) GROUP BY u.Id) AS answers JOIN Users AS u ON (u.Id = answers.UserId) ORDER BY 1 DESC