SQL Server Functionality: Joining Multiple Columns with Sum Up Using CASE Statement

Understanding the Impact of the EXISTS Clause When Comparing Stored Procedure and Query Count