Snippet 001

SELECT sex, COUNT(DISTINCT PROCHI) AS PatientCount
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

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

df