title: SELECT how many movies where made in a year
body: <p>I have two rows in my database, one row is for the movies, the other one is for the year a movie was made</p>
  
  <p>I would like to select every movies and check how many were made in a specific year, it has to be every year. </p>
  
  <p>The output should look like this: </p>
  
  <pre><code>2018 = 819
  2017 = 910
  2016 = 128
  2015 = 539
  </code></pre>
  
  <p>What I tried: </p>
  
  <pre><code>SELECT LEFT(movie,4), COUNT(year) FROM movies GROUP BY LEFT(movie,4);
  </code></pre>
  
  <p>but it only outputs the name of the movies</p>
  
  <p>Thanks for reading.</p>