1with engine.connect() as conn:2    df = pd.read_sql("""3        SELECT TOP 204               s.PROCHI,5               d.sex,6               d.Calculated_Age,7               COUNT(*) AS TotalAdmissions,8               SUM(s.LENGTH_OF_STAY) AS TotalDays9        FROM Project_12345..SMR01_Admissions s10        INNER JOIN Project_12345..Demography_Current d11            ON s.PROCHI = d.PROCHI12        GROUP BY s.PROCHI, d.sex, d.Calculated_Age13        ORDER BY TotalAdmissions DESC14    """, conn)15 16df

1df <- dbGetQuery(conn, "2    SELECT TOP 203           s.PROCHI,4           d.sex,5           d.Calculated_Age,6           COUNT(*) AS TotalAdmissions,7           SUM(s.LENGTH_OF_STAY) AS TotalDays8    FROM Project_12345..SMR01_Admissions s9    INNER JOIN Project_12345..Demography_Current d10        ON s.PROCHI = d.PROCHI11    GROUP BY s.PROCHI, d.sex, d.Calculated_Age12    ORDER BY TotalAdmissions DESC13")14 15df