Question 2 on the “Hacker News” project says: Recent studies have found that online forums tend to be dominated by a small percentage of their users (1-9-90 Rule). Is this true of Hacker News? Is a small percentage of Hacker News submitters taking the majority of the points? First, find the total
score of all the stories etc.
I did that and it was all fine - but it struck me the exercise they asked us to do didn’t follow the preamble to the question. The exercise took popularity (points) as the key metric, whereas the preamble to the question was talking about the volume of titles/contributions. So I set about trying to find:
a) How many users were responsible for contributing articles, as a % of total users.
b) How many users were “super contributors” - had contributed more than one article.
I got myself this far (see screenshot), but I don’t know how to count up the number of “super contributor” users I’ve identified from here. Could someone point me in the right direction, please?
Query I put in:
SELECT user, COUNT(title) AS ‘# of Contributions’
GROUP by user
ORDER by 2 DESC;