Calculate Percentage Against Total for a Specified Condition in SQL Server Using Window Functions.

SQL Window Functions for Aggregate Calculations with the COALESCE and MAX Approach