欧美1区2区3区激情无套,两个女人互添下身视频在线观看,久久av无码精品人妻系列,久久精品噜噜噜成人,末发育娇小性色xxxx

有貸款信息表：loan_tb（agreement_id：合同id，customer_id：客戶id，loan_amount：貸款金額，pay_amount：已還金額，overdue_days：逾期天數(shù)） agreement_id customer_id loan_amount pay_amount overdue_days 10111 1111 20000 18000 NULL 10112 1112 10000 10000 NULL 10113 1113 15000 10000 38 10114 1114 50000 30000 NULL 10115 1115 60000 50000 NULL 10116 1116 10000 8000 NULL 10117 1117 50000 50000 NULL 10118 1118 25000 10000 5 10119 1119 20000 1000 106 客戶信息表：customer_tb（customer_id：客戶id，customer_age：客戶年齡，pay_ability：還款能力級(jí)別） customer_id customer_age pay_ability 1111 28 B 1112 38 A 1113 20 C 1114 30 A 1115 29 B 1116 21 C 1117 35 B 1118 36 B 1119 25 C 請(qǐng)根據(jù)以上數(shù)據(jù)分析各還款能力級(jí)別的客戶逾期情況，按照還款能力級(jí)別統(tǒng)計(jì)有逾期行為客戶占比。要求輸出還款能力級(jí)別、逾期客戶占比。 注：逾期客戶占比要求按照百分?jǐn)?shù)形式輸出并四舍五入保留 1 位小數(shù)，最終結(jié)果按照占比降序排序。 示例數(shù)據(jù)結(jié)果如下： pay_ability overdue_ratio C 66.7% B 25.0% A 0.0% 結(jié)果解釋： 還款能力級(jí)別為 C 的客戶有1113、1116、1119，其中有逾期行為的客戶為 1113、1119，故結(jié)果為 23=66.7%；其他結(jié)果同理。
示例1

輸入

drop table if exists  `loan_tb` ; 
CREATE TABLE `loan_tb` (
`agreement_id` int(11) NOT NULL,
`customer_id` int(11) NOT NULL,
`loan_amount` int(11) NOT NULL,
`pay_amount` int(11) NOT NULL,
`overdue_days` int(11),
PRIMARY KEY (`agreement_id`));
INSERT INTO loan_tb VALUES(10111,1111,20000,18000,null); 
INSERT INTO loan_tb VALUES(10112,1112,10000,10000,null); 
INSERT INTO loan_tb VALUES(10113,1113,15000,10000,38); 
INSERT INTO loan_tb VALUES(10114,1114,50000,30000,null); 
INSERT INTO loan_tb VALUES(10115,1115,60000,50000,null); 
INSERT INTO loan_tb VALUES(10116,1116,10000,8000,null); 
INSERT INTO loan_tb VALUES(10117,1117,50000,50000,null); 
INSERT INTO loan_tb VALUES(10118,1118,25000,10000,5); 
INSERT INTO loan_tb VALUES(10119,1119,20000,1000,106); 

drop table if exists  `customer_tb` ; 
CREATE TABLE `customer_tb` (
`customer_id` int(11) NOT NULL,
`customer_age` int(11) NOT NULL,
`pay_ability` varchar(2) NOT NULL,
PRIMARY KEY (`customer_id`));
INSERT INTO customer_tb VALUES(1111,28,'B'); 
INSERT INTO customer_tb VALUES(1112,38,'A'); 
INSERT INTO customer_tb VALUES(1113,20,'C'); 
INSERT INTO customer_tb VALUES(1114,30,'A'); 
INSERT INTO customer_tb VALUES(1115,29,'B'); 
INSERT INTO customer_tb VALUES(1116,21,'C'); 
INSERT INTO customer_tb VALUES(1117,35,'B'); 
INSERT INTO customer_tb VALUES(1118,36,'B'); 
INSERT INTO customer_tb VALUES(1119,25,'C');

輸出

pay_ability|overdue_ratio
C|66.7%
B|25.0%
A|0.0%
加載中...