Snippet 011

SELECT TOP 20
       MAIN_CONDITION,
       COUNT(*) AS AdmissionCount
FROM Project_12345..SMR01_Admissions
GROUP BY MAIN_CONDITION
ORDER BY AdmissionCount DESC

with engine.connect() as conn:
    df = pd.read_sql("""
        SELECT TOP 20
               MAIN_CONDITION,
               COUNT(*) AS AdmissionCount
        FROM Project_12345..SMR01_Admissions
        GROUP BY MAIN_CONDITION
        ORDER BY AdmissionCount DESC
    """, conn)

df

df <- dbGetQuery(conn, "
    SELECT TOP 20
           MAIN_CONDITION,
           COUNT(*) AS AdmissionCount
    FROM Project_12345..SMR01_Admissions
    GROUP BY MAIN_CONDITION
    ORDER BY AdmissionCount DESC
")

df