56,675
社区成员
发帖
与我相关
我的任务
分享
select
case
when price between 0 and 3 then 1
when price between 3 and 6 then 2
when price between 6 and 10 then 3
end,
count(*)/(select count(*) from 我有一个表A)
from 我有一个表A
group by case
when price between 0 and 3 then 1
when price between 3 and 6 then 2
when price between 6 and 10 then 3
end
select
case
when price between 0 and 3 then 1
when price between 3 and 6 then 2
when price between 6 and 10 then 3
end,
count(*)
from 我有一个表A
group by case
when price between 0 and 3 then 1
when price between 3 and 6 then 2
when price between 6 and 10 then 3
end