sql server equivalent of a countif aggregate function

Intermediate SQL Tutorial | Case Statement | Use Cases CASE WHEN Statements (SQL) - Conditional Logic (If Then) Case Statements in MySQL | Intermediate MySQL SQL Tutorial - Nesting CASE statements How to Use a Case Statement in a Select Query | SQL Server SQL \"difference between\" interview questions (part 1) SOLVE 5 SQL QUERIES IN 5 MINUTES (PART 1) | MASTER IN SQL | SQL INTERVIEW QUESTIONS 6 SQL Joins you MUST know! (Animated + Practice) #34 Select Null Statement in SQL | SQL Tutorial CASE statement with IS NULL and NOT NULL SQL Tutorial: CASE WHEN with aggregate functions SQL CASE CASE STATEMENT(IF THEN ELSE) IN ORACLE SQL WITH EXAMPLE Master the SQL SELECT statement part 03: CASE CASE Expressions and CASE Statements UNION Operator (SQL) - Combining Results (UNION, UNION ALL) Magic of CASE statement || Handling with nulls || SQL 🎥CASE Statement in SQL | Learn Conditional Logic in SQL Easily | PART 16〽️ SQL: Handle Case When Null Issues FAST