SamtheBrand
|
Registered User
|
- select f.PostId, p.ParentId, p.PostTypeId, f.CreationDate...
- Count of users who posted 1, 5, 10, or 20x in preceding 30 day rolling period
- Rolling 7-Day Count of Posters
- Posts with tag by day
- Edits in a year
- Anonymous Feedback + Votes over time on a Specific Tag
- Anonymous Feedback on Tags Over Time
- Anonymous Feedback - Top Posts
- hotness for a period
- Answers that wowed
- Answers per Month before and after Legendary Badge
- select * from Users u join Badges b on u.Id = b.UserId wh...
- select * from Badges
- How many unique answerers per month
- distinct posters