title: SQL BETWEEN offset upbound or not
body: <p>To search for movies that begin with the letters 'D', 'E', and 'F' my code is</p>
  
  <pre><code>SELECT *
  FROM movies
  WHERE name BETWEEN 'D%' AND 'G%';
  </code></pre>
  
  <p>Why is 'G' the upbound instead of 'F', especially when the upbound in the following code is 1979 instead of 1980 to look for movies from the 70s?  Why does the first example need to be offset by one while the example below doesn't?</p>
  
  <pre><code>SELECT *
  FROM movies
  WHERE year BETWEEN 1970 and 1979;
  </code></pre>