某物流公司快递信息数据及快递费用数据如下： 快递信息表express_tb(exp_number-快递单号,exp_type-快递种类,out_city-快递发出城市,in_city-快递邮入城市,create_time-快递单创建时间)，如下所示： 快递费用信息表exp_cost_tb(exp_number-快递单号,transport_cost-运费,insurance_cost-运费险,claims_cost-快递损坏理赔费用)，如下所示： 问题：请查询产生理赔金额的快递信息？ 要求输出：快递单号、快递种类、理赔费用（按照理赔费用降序排序） 知识点：关联查询、条件查询 示例数据结果如下： 解释：快递单号为11103、11105产生理赔费用 故结果如上
示例1

输入

drop table if exists  `express_tb` ; 
CREATE TABLE `express_tb` (
`exp_number` int(11) NOT NULL,
`exp_type` varchar(16) NOT NULL,
`out_area` varchar(16) NOT NULL,
`in_area` varchar(16) NOT NULL,
`create_time` datetime NULL,
PRIMARY KEY (`exp_number`));
INSERT INTO express_tb VALUES(11101,'file','city1','city2','2022-05-02 09:00:00');  
INSERT INTO express_tb VALUES(11102,'C&A','city3','city4','2022-05-02 09:00:05');
INSERT INTO express_tb VALUES(11103,'file','city1','city4','2022-05-02 09:00:12');
INSERT INTO express_tb VALUES(11104,'food','city1','city2','2022-05-02 09:00:15');
INSERT INTO express_tb VALUES(11105,'food','city2','city3','2022-05-02 09:00:35');
INSERT INTO express_tb VALUES(11106,'C&A','city1','city3','2022-05-02 09:01:00');
INSERT INTO express_tb VALUES(11107,'file','city2','city1','2022-05-02 09:01:23');
INSERT INTO express_tb VALUES(11108,'digitalproduct','city3','city2','2022-05-02 09:01:30');

drop table if exists  `exp_cost_tb` ; 
CREATE TABLE `exp_cost_tb` (
`exp_number` int(11) NOT NULL,
`transport_cost` int(11) NOT NULL,
`insurance_cost` int(11) NULL,
`claims_cost` int(11) NULL,
PRIMARY KEY (`exp_number`));
INSERT INTO exp_cost_tb VALUES(11101,15,null,null);  
INSERT INTO exp_cost_tb VALUES(11102,23,null,null);
INSERT INTO exp_cost_tb VALUES(11103,22,3,50);
INSERT INTO exp_cost_tb VALUES(11104,11,null,null);
INSERT INTO exp_cost_tb VALUES(11105,14,2,25);
INSERT INTO exp_cost_tb VALUES(11106,18,null,null);
INSERT INTO exp_cost_tb VALUES(11107,35,4,null);
INSERT INTO exp_cost_tb VALUES(11108,40,6,null);

输出

exp_number|exp_type|claims_cost
11103|file|50
11105|food|25
加载中...