我的目標是對一個范圍內的所有值進行求和，并將這個和除以這個值的總數。
通過下面的查詢，我可以使用GROUP BY來求和：
select<
sum(cast(json_data -> 'surface_extension' ->。 'cold' -> ' percentage' as float) as cold_perc,
sum(cast(json_data -> 'surface_extension' ->。 'coolest' -> ' percentage' as float) as coolest_perc,
sum(cast(json_data -> 'surface_extension' -> 'comfort' -> ' percentage' as float) as comfort_perc,
sum(cast(json_data -> 'surface_extension' -> 'hot' -> ' percentage' as float) as hot_perc,
sum(cast(json_data -> 'surface_extension' -> 'very_hot' -> ' percentage' as float) as very_hot_perc,
地區_城市_id
from project_urbaninfo
where area_urban_id = 3 and item_service_id= 29 and infotype_id = 1
group by area_urban_id
通過下一個查詢，我可以計算所有的值：
select count（1)
from project_urbaninfo
where area_urban_id = 3 and item_service_id= 29 and infotype_id = 1
我的問題是如何加入這兩個結果。
編輯：我的目標是獲得類似這樣的結果：
uj5u.com熱心網友回復： 請試一下。
標籤：sum(sum)()()
sum(cast(json_data -> 'surface_extension' -> 'cold' -> 'percent' as float)) / COUNT as cold_percselect
sum(cast(json_data -> 'surface_extension' ->/span> 'cold' -> ' percentage' as float)）/COUNT(1) as cold_perc,
sum(cast(json_data -> 'surface_extension' -> 'coolest' -> ' percentage' as float）)/COUNT(1) as coolest_perc,
sum(cast(json_data -> 'surface_extension' -> ' comfort' -> ' percentage' as float)）/COUNT(1) as comfort_perc,
sum(cast(json_data -> 'surface_extension' -> 'hot'> ' percentage' as float）)/COUNT(1) as hot_perc,
sum(cast(json_data -> 'surface_extension' -> 'very_hot' -> ' percentage' as float）)/COUNT(1) as very_hot_perc,
地區_城市_ID
from project_urbaninfo
where area_urban_id = 3 and item_service_id= 29 and infotype_id = 1
group by area_urban_id