1SELECT TOP 202       MAIN_CONDITION,3       COUNT(*) AS AdmissionCount4FROM Project_12345..SMR01_Admissions5GROUP BY MAIN_CONDITION6ORDER BY AdmissionCount DESC
1with engine.connect() as conn:2    df = pd.read_sql("""3        SELECT TOP 204               MAIN_CONDITION,5               COUNT(*) AS AdmissionCount6        FROM Project_12345..SMR01_Admissions7        GROUP BY MAIN_CONDITION8        ORDER BY AdmissionCount DESC9    """, conn)10 11df
1df <- dbGetQuery(conn, "2    SELECT TOP 203           MAIN_CONDITION,4           COUNT(*) AS AdmissionCount5    FROM Project_12345..SMR01_Admissions6    GROUP BY MAIN_CONDITION7    ORDER BY AdmissionCount DESC8")9 10df