select ceiling((zdarea-100)/50),zdarea, case when zdarea < 100 then 13
-- when ytarea >= 100 and ytarea <150 then 18-- when ytarea >= 150 and ytarea <200 then 23-- when ytarea >= 200 and ytarea <250 then 28 else --(case convert(int,(zdarea-100)/50) when 0 then 18 when 1 then 23 when 2 then 28 else 30 end) (case ceiling((zdarea-100)/50) when 1 then 18 when 2 then 23 when 3 then 28 else 30 end) endFrom roomWhere 1=1 and areaname like '%安庆碧桂园%' and zdarea>100
Select ceiling((zdarea-100)/50),zdarea, (case when zdarea<100 then 13 when (ceiling((zdarea-100)/50)*5+13)>30 then 30 else (ceiling((zdarea-100)/50)*5+13) end ) From room Where 1=1 and areaname like '%安庆碧桂园%'
