title: How to count non-null/non-blank values in SQL
body: <p>I have data like the following:</p>
  <p><a href="https://i.stack.imgur.com/3p9SF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3p9SF.png" alt="Data" /></a></p>
  
  <p>And what I want is to count the PONo, PartNo, and TrinityID fields with a value in them, and output data like this:</p>
  <p><a href="https://i.stack.imgur.com/XZa7D.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XZa7D.png" alt="Desired Output" /></a></p>
  
  <p>How can I do this counting in SQL?</p>