题解 | 查询产生理赔费用的快递信息
查询产生理赔费用的快递信息
https://www.nowcoder.com/practice/d22eab8a0001443fba7c5757e7cbcaea
select b.exp_number, a.exp_type, b.claims_cost from exp_cost_tb b join express_tb a using (exp_number) where b.claims_cost > 0 order by b.claims_cost desc