Question:Imagine this table:
So the ideal output is:
falsefor all due to the null values.
What is the best way to achieve the output above?
Answer:You could transform the columns to rows, the count the distinct values. That will automatically ignore NULL values:
If you have better answer, please add a comment about this, thank you!