Stack Exchange Data Explorer
Feb 13 '13 at 20:45
WITH RankedPosts AS ( SELECT ROW_NUMBER() OVER (PARTITION...
SELECT TOP 10 * from Posts q LEFT JOIN Posts a ON q.Acce...
SELECT TOP 10 OwnerUserId [User Link], AVG(Score) AvgScor...
Declare @userid INT = ##UserId## SELECT Top 1 * FROM Posts
Posts each day of week by users less than one week old (1 year)
Posters/Commenters/Editors Last Month
100 users with the lowest reputation who have earned a gold badge (EXISTS)
100 users with the lowest reputation who have earned a gold badge (IN clause)
Ten users with most gold badges
SELECT TOP 10 Users.Id, COUNT(*) FROM Users JOIN Posts ON...
10 users with the top average answer score
Avg rep for 10 users with most answers
Most rep in new contest
New contest users & avg rep
50 top-voted comments for the month of November
site design / logo © 2020 Stack Exchange Inc; user contributions licensed under
cc by-sa 4.0