向下取整 floor (地板)
math.floor(-2.2)
# -3.0
math.floor(2.2)
# 2.0
向上取整 ceil (天花板)
math.ceil(-2.2)
# -2.0
math.ceil(2.2)
# 3.0
舍入 round
round(2.24, 1)
# 2.2
round(2.26, 1)
# 2.3
select substr(riqi,1,7),count(*),ceil((sum(zongjia*10000)/sum(mianji))) from bj_fang where riqi like '2017%' or riqi like '2016%' group by substr(riqi,1,7)