title: SQL decimal places within a select statement
body: <p>I've been reading threads and seeing the 'Convert' and 'Cast' commands, but I cannot get any to fit in this simple select statement.  Very frustrating to have to ask a question this simple, but I cannot find anything that works.  Below is the code, and I need the 'discount amount/price' to show up with 2 decimal places.  Thank you in advance. </p>
  
  <pre><code>select product_name, list_price, discount_percent, list_price * 
  (discount_percent*.01) as 'discount_amount', 
  list_price - (list_price * (discount_percent*.01)) as 'discount_price'
  from products
  order by discount_price desc
  limit 5;
  </code></pre>