Analyse data with SQL Hacker News Task 4

Projects Skill Path Projects
1

So the task is add these users’ score`s together and divide by the total to get the percentage with following example:

Add their scores together and divide it by the total sum. Like so:

SELECT (1.0 + 2.0 + 3.0) / 6.0;

So I thought this would be something like this:

SELECT(517 + 309 + 304 + 282 / 1412)

The four user scores divided by the total which is 1412 yet looking at the hint it gives the following:

SELECT(517 + 309 + 304 + 282 / 6366.0)

So the 6366.0 is the sunm of all scores of the table? As the way it is worded suggests to me that it is the total score of the user scores, not the total score of the table.

2

What does the question say? Please provide a link to the lesson.

Is the question something like, ‘What percent are these users’ scores of the total of all scores?’

To find the percentage of those scores you would need to divide by the total of all of the scores.

3

I’ve clearly misunderstood it but it literally says:

4.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.

Hacker News Tasks

4

I see how it could be confusing. But, they’re presupposing that one knows in order to get a percentage (of the whole) here, that the denominator in the calculation is the total of all of the scores. (numerator being those users’ scores).

the part/the whole
1 Like