title: SQL count how many male and femal in the same type
body: <p><a href="https://i.stack.imgur.com/RqR7k.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RqR7k.png" alt="sample database"></a></p>
  
  <p>Above is my participants table and my problem is I want to count how many male and female are the same type of participant. Below is the code I have that count how many participant per type.</p>
  
  <pre><code>SELECT type_parti, COUNT(1) FROM tbl_participants GROUP BY type_parti
  </code></pre>