title: Why does the code 'ORDER BY rating DESC' cause an error in my code?
body: <p>In the cs50 class I was assigned to list all of the movies in 2012 and their ratings, in descending order by rating in sql. When I made this code the error</p>
  <blockquote>
  <p>'line 12:  2111 File size limit exceeded/usr/bin/sqlite3 -header
  -separator ' | ' &quot;$@&quot;'</p>
  </blockquote>
  <p>and I would like to know why.</p>
  <pre><code>SELECT title, rating FROM movies, ratings
  WHERE year = 2012 AND movie_id IN (SELECT id FROM movies
  WHERE year = 2012)
  ORDER BY rating DESC
  </code></pre>
  <p>The error does go away after I remove 'ORDER BY rating DESC', but I cannot do that because check50 wouldn't accept it.</p>