能支支持这样的计算吗

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

我看好象是不支持这样的查询,求助