title: How to fix this simple MySQL query
body: <p>I have a small problem - I'm learning mysql and I can't wrap my head around the problem I'm trying to solve. 
  I created 2 tables - first has <code>users (id, name , birth)</code> - second has <code>transactions ( id , user_id , deposit , withdraw, date)</code></p>
  
  <p>I have a simple query that should return
  names with deposits and withdraws from each month from the past 6 months.</p>
  
  <p>Currently I have 5 entries in users with dummy data generated for transactions.</p>
  
  <p>I've tried to switch things up abit in the query but nothing returns more than 1 name. I've checked stackoverflow search but the amount of information seems endless yet I've yet to find the answer I'm looking for (for my specific problem).</p>
  
  <pre><code>SELECT
      T1.name,
      T2.deposit,
      T2.withdraw,
      DATE_FORMAT(T2.date, '%M-%Y') transactions
  FROM
      users AS T1
  INNER JOIN transactions AS T2
  ON
      T1.id = T2.user_id
  WHERE
      DATE_FORMAT(T2.date, '%m') BETWEEN '06' AND '12'
  GROUP BY
      DATE_FORMAT(t2.date, '%m');
  </code></pre>
  
  <p>I expect each name to display transactions made from each month</p>
  
  <p>but the result is the following </p>
  
  <p><a href="http://prntscr.com/mfe0zs" rel="nofollow noreferrer">http://prntscr.com/mfe0zs</a></p>
  
  <p>so just results from the first deposit or withdraw that he can find for the month and just for the first name.</p>