Order Status Percentage

For each order status return the number of orders and the percentage of all orders it represents, rounded to two decimals. Order by order_count descending.

Table schema

Orders(id INT PRIMARY KEY, status VARCHAR(20))

Sample data

id | status
1 | Delivered
2 | Delivered
3 | Cancelled
4 | Delivered