title: SQL order of operations
body: <p>If I run the following SQL query</p>
  
  <pre><code>SELECT * 
  FROM A
  LEFT JOIN B
  ON A.foo=B.foo
  WHERE A.date = "Yesterday"
  </code></pre>
  
  <p>Does the <code>WHERE</code> statement get evaluated before or after the <code>JOIN</code>? </p>
  
  <p>If after, what would be a better way to write this statement so that returns only rows in <code>A</code> from <code>"Yesterday"</code> are joined to <code>B</code>?</p>