How to Achieve Different Conditions on the Same Column Without Unexpected Results in SQL

Understanding SQL Group By and Having Clauses: Best Practices for Data Aggregation and Filtering