Applying Multiple Conditions on the Same Column with AND Operator in SQL Server 2008 R2

Counting Column Values Efficiently in SQL: A Comprehensive Guide to Avoiding Hardcoded Values and Improving Performance