title: Getting error code 1064 for SELECT statement in MySQL Workbench. Unsure why
body: <p>Just started MySQL class using Murach's MySQL 2nd Edition. Using MySQL Workbench, I 'm getting a 1064 error code for a <code>SELECT</code> statement I am trying to perform. I'm stumped. Here is my <code>SELECT</code> statement.</p>
  
  <pre><code>SELECT item_id, item_price, discount_amount,
         quantity * item_price AS price_total,
         quantity * discount_amount AS discount_total,
         price_total - discount_total AS item_total
  FROM order_items
  ORDER BY item_total DESC
  WHERE  item_total &gt; 500
  </code></pre>