Each cat would like to know what percentage of cats weight less than it
Return: name, weight, percent
Order by: weight Show Table Schema
Correct output but can you use 'percent_rank'?
percent_rank() scores everything from 0 - 1 allowing us to generate distributions or percentiles next question
select name, weight, percent_rank() over (order by weight) * 100 as percent from cats order by weight