COUNT(column) vs COUNT(*) in SQL — With INNER, LEFT, RIGHT & FULL JOIN Explained

Counting seems simple in SQL… until joins enter the picture. One of the most common bugs...