Unlocking Data Insights with SQL Server's GROUP BY Clause and CASE Statements: A Comprehensive Guide