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