title: Column count based on a condition
body: <p>I have created an oracle query like as shown below,the query is working fine
  but the problem is that I want one more column which is the count of name where category should be A and id should be 1</p>
  
  <pre><code>SELECT name, velocity, COUNT(*) AS count, category FROM section GROUP BY name, velocity
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/YDNCS.png" rel="noreferrer"><img src="https://i.stack.imgur.com/YDNCS.png" alt="enter image description here"></a></p>
  
  <p>Can anyone please tell me some solution for this</p>