COUNT in SQL, Explained for Beginners

COUNT looks like the simplest function in SQL, and it is the one that quietly trips up the most people in interviews and on the job. The confusion is almost always the same: COUNT(*), COUNT(column), a