构造一个关联字段,使用left join,例如求出总和,再求占比:
with a as (select name,count(1) as c,1 as j from t1 group by name),
b as (select count
构造一个关联字段,使用left join,例如求出总和,再求占比:
with a as (select name,count(1) as c,1 as j from t1 group by name),
b as (select count