Percentages
Question:
Each cat would like to know what percentage of other cats weigh less than it
Return: name, weight, percent
Order by: weight
Show Table
Cats:
| name | varchar |
| breed | varchar |
| weight | float |
| color | varchar |
| age | int |
Show Desired Output
Desired output:
| name | weight | percent |
| Tigger | 3.80 | 0.00 |
| Molly | 4.20 | 9.09 |
| Ashes | 4.50 | 18.18 |
| Charlie | 4.80 | 27.27 |
| Smudge | 4.90 | 36.36 |
| Felix | 5.00 | 45.46 |
| Puss | 5.10 | 54.55 |
| Millie | 5.40 | 63.64 |
| Alfie | 5.50 | 72.73 |
| Misty | 5.70 | 81.82 |
| Oscar | 6.10 | 90.91 |
| Smokey | 6.10 | 90.91 |
Query Window:
Correct output but can you use 'percent_rank'?
×
Good work!
percent_rank() scores everything from 0 - 1 allowing us to generate distributions or percentiles next question
Show Answer
Answer:
select name, weight,
percent_rank() over (order by weight) * 100 as percent
from cats order by weight