Denis Gobo shows how you can find the percentage of NULL (or non-NULL) values in a column:
This came up the other day, someone wanted to know the percentage of NULL values in a column
Then I said “I bet you I can run that query without using a NULL in the WHERE clause, as a matter of fact, I can run that query without a WHERE clause at all!!”
Bonus lesson: maybe don’t bet against Denis.