Metric

Cancellation rate

Cancelled orders divided by all orders, as a percentage.

SELECT ROUND(100.0 * COUNT(*) FILTER (WHERE status = 'cancelled') / COUNT(*), 1)
FROM orders;

SELECT COUNT(*) AS orders,
       COUNT(*) FILTER (WHERE status = 'cancelled') AS cancelled,
       ROUND(100.0 * COUNT(*) FILTER (WHERE status = 'cancelled') / COUNT(*), 1) AS cancel_rate_pct
FROM orders;

orders	cancelled	cancel_rate_pct
2500	149	6.0

orders

cancelled

cancel_rate_pct

2500

149

6.0

Try it in Randori

Practise:The cancellation rate