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
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
another option is to use sotagtrends.com
CDF of Question Count vs. time
Get Top Tags
https://data.stackexchange.com/datascience/query/1486534
SELECT TOP(100)
TagName,
COUNT(*) AS popularity
FROM Tags
INNER JOIN PostTags ON PostTags.TagId = Tags.id
GROUP BY TagName
ORDER BY 2 DESC
siddharth's space 