能支支持这样的计算吗

[lonely7345]

indices为这样的数据 zone code colo count 我想计算出每个zone code >400的数量 占每zone的总数的百分比 with all_data as (select zone, sum(count) t1 from dd group by zone) with all_fail as (select zone,sum(count) t2 from dd where code > 400 group by zone ) select all_fail.t2 /all_data.t1 from all_data join all_fail on all_data.zone = all_fail.zone

我看好象是不支持这样的查询,求助