round(cast(hospital_area as numeric) / cast(all_area as numeric) * 100,6)结果乘100,取6位小数,结果展示
select *,round(cast(hospital_area as numeric) / cast(all_area as numeric) * 100,6) as hospital_ratio_new,
round(cast(food_area as numeric) / cast(all_area as numeric) * 100,2) as food_tatio_new from area_relation_scenes
cast函数,将某个字段转成某种类型
例如:cast(hospital_area as numeric) 将hospital_area(原本是字符串的)转成numeric类型