COUNT in SQL, Explained for Beginners

Beginner guide to SQL COUNT: how COUNT(*), COUNT(column), and COUNT(DISTINCT column) differ, why NULLs make them disagree, how COUNT pairs with GROUP BY, and how analysts use COUNT to verify a data migration and check a real dataset.