title: Increase the unit price in the products table of all rows with a current unit price between $5.00 and $10.00 by 5%
body: <p>Okay so I'm doing some homework and here is the question I'm struggling with:</p>
  
  <p>Using the UPDATE statement, increate the unit_price in the products table of all rows with a current unit_price between $5.00 and $10.00 by 5%.</p>
  
  <p>My answer to this is:</p>
  
  <pre><code>UPDATE      products
  SET         unit_price = unit_price*1.05
  WHERE       unit_price BETWEEN 5.00 AND 10.00;
  GO
  </code></pre>
  
  <p>But I'm getting this error message:</p>
  
  <p>Conversion failed when converting the varchar value 'reorder_level' to data type int.</p>
  
  <p>Which makes no sense as the column 'reorder_level' is int already and has nothing to do with this sql statement. Am I writing the statement incorrectly? Help!</p>