kingledion
|
Registered User
|
- 7-day Rolling Average of Number of Questions Asked
- SELECT ROUND(POWER(EXP(SUM(CASE WHEN score > 0 THEN LOG(s...
- select UserId as [User Link], sum(bountyamount) from vote...
- select top 100 id as [Post Link], PostTypeId, ownerUserId...
- select a.id as [Post Link], c.score-b.score as diff, c.ow...
- Top users by bounties
- select UserId as [User Link], sum(bountyamount), creation...
- select UserId as [User Link], bountyamount, creationDate ...
- select UserId as [User Link], bountyamount from votes whe...
- Badges score
- select max(CreationDate) from posts
- Answers by post
- Percentage of anwers accepted
- select count(*) from posts where CreationDate > '2017-01-...
- select max(Id), count(*) from postswithdeleted