Stack Exchange Data Explorer
Mar 18 at 17:38
select top 5 * from users
Most common duplicate targets for a tag
select * from Tags targetTag where targetTag.TagName = #...
Avg Favorite Vote Count By Rep
Frequency of favorite votes
Total users on the site
Number of users that have favorited something
select * from ReviewTaskResults where ReviewTaskId = 19...
select se.Id [Suggested Edit Link], case when sev.VoteTyp...
select case when rtr.ReviewTaskResultTypeId = 1 then 'Not...
;with Data as ( select case when Score > 3 then ' 4 or...
select DATEPART(HOUR, p.CreationDate) [Posted Hour], avg(...
select t.TagName, avg(p.Score) [Avg], STDEV(p.Score) [Std...
;with Data as ( select answers.OwnerUserId, avg(answers.S...
Avg Answer and Question score for user's answers
site design / logo © 2019 Stack Exchange Inc; user contributions licensed under
cc by-sa 3.0