/*
联表：from express_tb t1 join exp_cost_tb t2 on t1.exp_number = t2.exp_number
计数 ：无
排序： order by claims_cost desc
筛选：where claims_cost is not null*/
select t1.exp_number
,exp_type
,claims_cost
from express_tb t1 join exp_cost_tb t2 on t1.exp_number = t2.exp_number
where claims_cost is not null
order by claims_cost desc