如何使用psql找到每个社区的区域比例?

问题描述

我有一张包含邻域、区域和地块大小的表.如何使用 Lot size 找到每个街区的区域比例??

I have a table with Neighbourhood, Zones and Lot size. How to find the proportion of zones in Each neighbourhood using Lot size ??

这是我的桌子:

Neighbourhood    Zones    Lotsize
Albany           RSL      415
Albany           RSL      410
Albany           PU       34621
Abbottsfield     RF5      24267
Abbottsfield     AP       9745
Abbottsfield     CSC      57799

推荐答案

这应该有效:

SELECT
    p.Neighbourhood,
    p.Zones,
    (CAST(COUNT(p.*) AS FLOAT) / CAST(
        (SELECT
            COUNT(*)
        FROM properties AS p1
        WHERE p1.Neighbourhood=p.Neighbourhood) AS FLOAT)
    ) AS proportion
FROM properties AS p
GROUP BY p.Neighbourhood, p.Zones;

(修改自我对我自己问题的回答 此处.)

(Modified from my answer to my own question here.)

这篇关于如何使用psql找到每个社区的区域比例?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！