Snippet 002

DECLARE @TotalPop AS INT
SELECT @TotalPop = COUNT(DISTINCT PROCHI)
FROM Project_12345..Demography_Current

SELECT sex,
       COUNT(DISTINCT PROCHI) AS PatientCount,
       COUNT(DISTINCT PROCHI) * 100.0 / @TotalPop AS Pct
FROM Project_12345..Demography_Current
GROUP BY sex

with engine.connect() as conn:
    df = pd.read_sql("""
        SELECT sex, COUNT(DISTINCT PROCHI) AS PatientCount
        FROM Project_12345..Demography_Current
        GROUP BY sex
    """, conn)

df["Pct"] = df["PatientCount"] / df["PatientCount"].sum() * 100
df

df <- dbGetQuery(conn, "
    SELECT sex, COUNT(DISTINCT PROCHI) AS PatientCount
    FROM Project_12345..Demography_Current
    GROUP BY sex
")

df$Pct <- df$PatientCount / sum(df$PatientCount) * 100
df