题解 | 查询产生理赔费用的快递信息
查询产生理赔费用的快递信息
https://www.nowcoder.com/practice/d22eab8a0001443fba7c5757e7cbcaea
select e.exp_number,e.exp_type,ec.claims_cost from express_tb e join exp_cost_tb ec on e.exp_number = ec.exp_number where ec.claims_cost is not null order by ec.claims_cost desc
简单