Preview:
​this one was tricky ...had to calculate ratio 

another egample

https://learnsql.com/track/advanced-sql/course/window-functions/over-partition-by/summary/question-2
downloadDownload PNG downloadDownload JPEG downloadDownload SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter