D 5 93000 0.5097
客户信息表 customer
字段名称:身份证号,客群类型,年龄
id_no groupp age
1100001990 house 29
5500001992 creditcard...27
2300001991 creditcard 28
4500001989 creditcard 30
4500001988 house 31
5100001992 car 46
5100001982...left JOIN customer
ON loan_list.id_no = customer.id_no
GROUP BY groupp;
☆ 结果:
groupp 人数占比
car 0.25
creditcard...int);
insert into customer values
("1100001990","house",29),
("5500001992","creditcard...",27),
("2300001991","creditcard",28),
("4500001989","creditcard",30),
("4500001988","house",31),
("5100001992