题解 | 查询产生理赔费用的快递信息
查询产生理赔费用的快递信息
https://www.nowcoder.com/practice/d22eab8a0001443fba7c5757e7cbcaea
select b.exp_number, a.exp_type, b.claims_cost from express_tb as a 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;