题解 | 物流公司想要分析快递小哥的收入情况

SELECT
    c.courier_id,
    c.courier_name,
    SUM(d.delivery_fee)+c.base_salary AS total_income
FROM
    couriers_info AS c
    INNER JOIN
    deliveries_info AS d ON c.courier_id=d.courier_id
WHERE
    DATE(d.delivery_date) BETWEEN '2024-07-01' AND '2024-07-31'
GROUP BY
    c.courier_id
ORDER BY
    c.courier_id;