title: How can we merge the results of two queries have group by and two conditions
body: <p>I have these two tables: (games)</p>
  
  <p><img src="https://i.stack.imgur.com/0a8rY.png" alt="games table"></p>
  
  <p>and (rounds) table:</p>
  
  <p><img src="https://i.stack.imgur.com/nlboi.png" alt="rounds table"></p>
  
  <p>I would like to get the game id's, there round count, and the count of how many rounds that player1 wins. I created two sql queries like this:</p>
  
  <p><img src="https://i.stack.imgur.com/Ni8cY.png" alt="queries and results"> </p>
  
  <p>but I want to get all results in one table. How can I combine the results to be like this:
  <img src="https://i.stack.imgur.com/XF9nf.png" alt="enter image description here"></p>