search

oldoc63 / learningDS

Learning DS with Codecademy and Books
0 stars 0 forks source link

Hacker News Moderating #255

Open oldoc63 opened 2 years ago

oldoc63 commented 2 years ago

Recent studies have found that online forums tend to be dominated by a small percentage of their users (1-9-90 Rule). If 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.

oldoc63 commented 2 years ago

Next, we need to pinpoint the users who have accumulated a lot of points across their stories. Find the individual users who have gotten combined scores of more than 200, and their combined scores. GROUP BY and HAVING are needed!

oldoc63 commented 2 years ago

Then, we want to add these users' scores together and divide by the total to get the percentage. Add their scores together and divide it by the total sum.

oldoc63 commented 2 years ago

While we are looking at the power users, some are tricking readers into clicking on a link to a funny video!

oldoc63 commented 2 years ago

How many times has each offending user posted this link?