title: I have issue grouping data value by year from mysql
body: <p>I have two columns in mysql tb namely date and value, the db store data value every day, Please I have problem of grouping the value by year.</p>
  
  <p>I tried this sql:</p>
  
  <pre><code>$sql = "SELECT value  FROM data GROUP BY  Year(date)";
  $query = mysqli_query($mysqli, $sql);
  </code></pre>
  
  <p>But I only get the result of the first day.
  Please I want fetch the result like this:</p>
  
  <p><a href="https://i.stack.imgur.com/IS4Jg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/IS4Jg.png" alt="this is how I want the result arrange"></a></p>
  
  <p>Thank you</p>