Using COUNT() Correctly: Avoiding Common Pitfalls with Subqueries and Aggregates in SQL Queries