title: SQL - Trouble using COUNT query
body: <p>Good day again to all SQL guru here :)</p>
  
  <p>I have a problem querying my table using COUNT.</p>
  
  <p>This is the data inside of the table (tblstudentoffense)</p>
  
  <p><a href="https://i.stack.imgur.com/vs8z6.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vs8z6.png" alt="enter image description here"></a></p>
  
  <p>And this is the RESULT that I want (Let's say that there is a new column after the offenseType that will count the Stealing and Gaming Offense</p>
  
  <p><a href="https://i.stack.imgur.com/3BrYK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3BrYK.png" alt="enter image description here"></a></p>
  
  <p>Is this possible? If possible kindly add an explanation with your provided code. Thanks :)</p>