From: Emeka Obi, Chief Operating Officer

One script, four truths. This is the query set the pack is built from.

1. The real failure rate: failed attempts as a share of attempts, with the ghost records (the pre-fix system retries) excluded - raw rate alongside for contrast. 2. The weight leakage: shipments where actual weight is well above declared, count and the revenue gap in naira (remember our amounts are stored in kobo). 3. The honest COD position: COD collected on genuinely COD shipments only, with the mis-flagged records quantified separately. 4. The service number: your Episode 5 query, brought in unchanged.

Paste the SQL and the four result sets. Label each with its correction, in comments.