有表a如下：
id money
01 1万
02 4.5万
03 1万
04 2万
05 4万
06 10万
07 10万
08 8万
09 15万
10 14万
要求通过SQL语句显示如下结果：
1-3万 3
3-5万 2
5—10万 3
10万以上 2
请教如何用一条SQL 语句写出来？
问题解决马上给分，可加分
------解决方案--------------------
Select N '1-3万 ' As [Money], Count(id) As [Count] From A Where Cast(Replace([money], N '万 ', ' ') As Numeric(10, 1)) Between 1.0 And 3.0
Union All
Select N '3-5万 ' As [Money], Count(id) As [Count] From A Where Cast(Replace([money], N '万 ', ' ') As Numeric(10, 1)) Between 3.0 And 5.0
Union All
Select N '5-10万 ' As [Money], Count(id) As [Count] From A Where Cast(Replace([money], N '万 ', ' ') As Numeric(10, 1)) Between 5.0 And 10.0
Union All
Select N '10万以上 ' As [Money], Count(id) As [Count] From A Where Cast(Replace([money], N '万 ', ' ') As Numeric(10, 1)) > 10.0
------解决方案--------------------
select case when cast(replace([money], '万 ', ' ') as numeric(18,2)) <=3.0 then '1-3万 '
when cast(replace([money], '万 ', ' ') as numeric(18,2))> 3.0 and cast(replace([money], '万 ', ' ') as numeric(18,2)) <=5.0 then '3-5万 '
when cast(replace([money], '万 ', ' ') as numeric(18,2))> 5.0 and cast(replace([money], '万 ', ' ') as numeric(18,2)) <=10.0 then '5-10万 '
when cast(replace([money], '万 ', ' ') as numeric(18,2))> 10.0 then '10万以上 '
end as 范围,
count(*) as 个数
from a
group by case when cast(replace([money], '万 ', ' ') as numeric(18,2)) <=3.0 then '1-3万 '
when cast(replace([money], '万 ', ' ') as numeric(18,2))> 3.0 and cast(replace([money], '万 ', ' ') as numeric(18,2)) <=5.0 then '3-5万 '
when cast(replace([money], '万 ', ' ') as numeric(18,2))> 5.0 and cast(replace([money], '万 ', ' ') as numeric(18,2)) <=10.0 then '5-10万 '
when cast(replace([money], '万 ', ' ') as numeric(18,2))> 10.0 then '10万以上 '
end