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
4 rows with columns status, orders, pct
Run your code to see the output here.