Build a CTE of order counts per status, then return each status with orders and pct of all orders (2 decimals), largest first.
status
orders
pct
Each hint gives a little more help. Try on your own first.
Run your code to see the output here.