Counting Distinct Units with Condition Based on Different Column in SQL

SQL Data Cleaning: How to Identify, Remove, and Return Unique IDs in Google BigQuery

How to Fix "Group By" Error in DB2 Query with Distinct Count

Understanding How to Count Distinct Values in SQL Groups