1DECLARE @TotalPop AS INT2SELECT @TotalPop = COUNT(DISTINCT PROCHI)3FROM Project_12345..Demography_Current4 5SELECT sex,6       COUNT(DISTINCT PROCHI) AS PatientCount,7       COUNT(DISTINCT PROCHI) * 100.0 / @TotalPop AS Pct8FROM Project_12345..Demography_Current9GROUP BY sex
1with engine.connect() as conn:2    df = pd.read_sql("""3        SELECT sex, COUNT(DISTINCT PROCHI) AS PatientCount4        FROM Project_12345..Demography_Current5        GROUP BY sex6    """, conn)7 8df["Pct"] = df["PatientCount"] / df["PatientCount"].sum() * 1009df
1df <- dbGetQuery(conn, "2    SELECT sex, COUNT(DISTINCT PROCHI) AS PatientCount3    FROM Project_12345..Demography_Current4    GROUP BY sex5")6 7df$Pct <- df$PatientCount / sum(df$PatientCount) * 1008df