Indicateur

Taux d'annulation

Les commandes annulées divisées par toutes les commandes, en pourcentage.

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

L’essayer en Randori

Pratiquer :Le taux d'annulation