Counting & Summarizing with GROUP BY

• COUNT(*) — number of rows. • COUNT(DISTINCT patient_id) — number of unique patients. • SUM(total_charges), AVG(...), MIN(...), MAX(...). • Aggregates ignore NULLs (except COUNT(*)).

SELECT COUNT(*) AS encounters, COUNT(DISTINCT patient_id) AS patients FROM encounters;