SQL Logic to Fail a Check if Any of the Related Customers Have Failed

Conditional Aggregation in SQL: A Comprehensive Guide to Counting Occurrences of Values

Using SQL Server's PIVOT Statement to Handle Zero Values in Count() Functions