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

1df <- dbGetQuery(conn, "2    SELECT sex, COUNT(DISTINCT PROCHI) AS PatientCount3    FROM Project_12345..Demography_Current4    GROUP BY sex5")6 7df