Solutions:
Check these solutions from our community and artificial intelligence:
The solution above is optimal because it uses the COUNT function with the DISTINCT keyword. This will count the number of unique values in each column.