title: How to get count of columns whose value greater than 40 from table
body: <p>I need to get column count whose value greater than 40 </p>
  
  <p><strong>example :</strong></p>
  
  <pre><code>id col_1 col_2 col_3
  
  1   20     60  80
  </code></pre>
  
  <p>The output like this <code>count=2</code></p>
  
  <p><strong>query:</strong></p>
  
  <pre><code>select count(columns) from table where id =1 and col_values &gt;40;
  </code></pre>
  
  <p>How to write query to get this please help me to write query.</p>