用于查找未被禁止的客户和司机的行程取消率的SQL代码

SELECT 
    c.customer_id,
    c.customer_name,
    d.driver_id,
    d.driver_name,
    COUNT(*) AS total_trips,
    SUM(CASE WHEN t.cancelled = 1 THEN 1 ELSE 0 END) AS cancelled_trips,
    SUM(CASE WHEN t.cancelled = 1 THEN 1 ELSE 0 END) / COUNT(*) AS cancellation_rate
FROM 
    trips t
JOIN 
    customers c ON t.customer_id = c.customer_id
JOIN 
    drivers d ON t.driver_id = d.driver_id
WHERE 
    c.status = 'active' AND d.status = 'active'
GROUP BY 
    c.customer_id, c.customer_name, d.driver_id, d.driver_name
HAVING 
    cancellation_rate < 0.2;