Understand the key differences between COUNT(*), COUNT(1), and COUNT(column_name) in SQL. This guide explains how each works, their performance implications, and when to use them for counting rows, including handling NULL values and optimizing queries with examples