Understanding the SQL Server CASE statement

SQL Operators - How to Use Them to Query Your Databases

SQL IF Statement introduction and overview

GROUP BY SQL Queries to Summarize and Rollup Sets of Records

SQL PARTITION BY Clause overview

Group By in SQL Server with CUBE, ROLLUP and GROUPING SETS Examples

Querying data using the SQL Case statement

CASE statement in SQL

SQL CASE Statement - Simple and Searched Forms - Essential SQL