请问一个SQL

[sklyn1984]

表 table, 里面有字段cnt1,cnt2,cnt3,city，所有字段都是number类型

按city分组查询，select city,sum(cnt1),sum(cnt2),sum(cnt3) group by city

但现在要得到sum(cnt1)/(sum(cnt1)+sum(cnt2)+sum(cnt3)) 的值，并且是这个值要大于阀值（假设阀值为F1）才符合要求，并且要计算出符合要求的，每一个地市的记录条数，要count，要知道每一组地市有多少条.

高手请教啊！

[dqsweet]

select SUM(case when sum(cnt1)/(sum(cnt1)+sum(cnt2)+sum(cnt3))>F1 then 1 else 0) group by city

[jillcomputer]

select city,count(*) group by city having sum(cnt1)/(sum(cnt1)+sum(cnt2)+sum(cnt3))>F1


F1你给成数字值吧 你给个F1让我怎么整

[jillcomputer]

复制你的都复制错了 你错我也错 下面这个正确
select city,count(*) from table group by city having sum(cnt1)/(sum(cnt1)+sum(cnt2)+sum(cnt3))>F1
少了from

[dreamover]

select city,sum(cnt1),sum(cnt2),sum(cnt3),count(*),(sum(cnt1)/(sum(cnt1)+sum(cnt2)+sum(cnt3)))
group by city having (sum(cnt1)/(sum(cnt1)+sum(cnt2)+sum(cnt3)))>F1