select group_type,count(*)/sum(count(*))over() as 类型占比
from customer
where customer.id_no in (select distinct id_no from loan_list)
group by group_type;
窗口函数sum(count(*))over()是一个计算后的定值，这里不受group by的影响------课后练习4的第三问