题解 | 查询产生理赔费用的快递信息
查询产生理赔费用的快递信息
https://www.nowcoder.com/practice/d22eab8a0001443fba7c5757e7cbcaea
SELECT
exp_cost_tb.exp_number,
exp_type,
claims_cost
FROM exp_cost_tb JOIN express_tb
ON exp_cost_tb.exp_number = express_tb.exp_number
WHERE claims_cost IS NOT NULL
ORDER BY claims_cost DESC
