Useful SO Queries

CDF of User Reputation

https://data.stackexchange.com/stackoverflow/query/1265631/cdf-of-so-reputation#graph

with cte as (select reputation, cume_dist() over (order by reputation) as cdf
from users)
select reputation, max(cdf) from cte
group by reputation
order by reputation;

According to this,

  • 71% of users have reputation <= 1. These are users who just created an account on the site.
  • 74% of users have reputation <= 10
  • 92% of users have reputation <= 100
  • 98% of users have reputation <= 1,000
  • 99.8% of users have reputation <= 10,000

also: http://rjbaxley.com/posts/2016/11/08/Stack_Exchange_Reputation_Power_Law.html

Question Count over time

https://data.stackexchange.com/stackoverflow/query/1290036/number-of-questions-asked-over-time-for-a-particular-topic-tag?Tag1=hyperledger-fabric#graph

DECLARE @Tag1 varchar(255)  = ##Tag1:string##;

    SELECT      DATEADD (month, DATEDIFF (month, 0, q.CreationDate), 0)  AS [Month],
    
    COUNT (q.Id)                AS NumQuests

    FROM        Posts           q
    INNER JOIN  PostTags        pt
    ON          q.Id            = pt.PostId
    INNER JOIN  Tags            t
    ON          t.Id            = pt.TagId

    WHERE       q.PostTypeId    = 1
    AND         q.CreationDate >= '2016-01-01 00:00:00'
    AND         t.TagName       IN (@Tag1)

    GROUP BY    DATEDIFF (month, 0, q.CreationDate), 
                t.TagName
    order by    DATEDIFF (month, 0, q.CreationDate)

below graph shows number of questions tagged hyperledger-fabric over time

number of questions tagged hyperledger-fabric over time.

CDF of Question Count vs. time

total number of questions over time
This entry was posted in Software. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s