How to count number of Cases in SQL?
<p>How can one find number of Cases in SQL? For example, following code has 5 Case statements</p>

<pre><code>Select
up.user_id,
(
    case when up.email is null then 0 else 1 end
    +
    case when up.bio is null then 0 else 1 end
    +
    case when up.website is null then 0 else 1 end
    +
    case when up.location is null then 0 else 1 end
    +
    case when up.name is null then 0 else 1 end
) * 100 / **5** as complete
from users_profiles up
</code></pre>

<p>I am using PostgreSQL</p>