题解 | 查询产生理赔费用的快递信息

SELECT
    e.exp_number,
    e.exp_type,
    ec.claims_cost
FROM
    express_tb AS e
    INNER JOIN
    exp_cost_tb AS ec ON e.exp_number=ec.exp_number
WHERE
    ec.claims_cost IS NOT NULL
ORDER BY
    ec.claims_cost DESC;