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

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