Amazon Interview Question

SQL Window function Get %out of a number