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

SELECT 
    a.exp_number,
    a.exp_type,
    b.claims_cost
FROM express_tb AS a
LEFT JOIN exp_cost_tb AS b
ON a.exp_number=b.exp_number
WHERE b.claims_cost is not NULL
ORDER BY b.claims_cost DESC;