title: Convert Y to 12% and N to 0
body: <p>The result of the discount table is Y,N . if Y = 12% if N = 0</p>
  <pre><code>select
      Product_id, basic_price, cost, discount
  from prcdpr
  where strdate = '210319' 
  </code></pre>
  <p>Also I want to add a formula above <code>(Price+cost)/discount</code>.</p>
  <p>My query result</p>
  <pre><code>Product_id          | basic_price   | cost         | Discount
  ------------------------------------------------------------
  998723              |  24           |   18         | Y
  992351              |  32           |   25         | N
  </code></pre>
  <p>My expected result with <code>(price+cost)/discount</code></p>
  <pre><code>Product_id          | basic_price        | cost         | Discount    | Price
  --------------------------------------------------------------------------
  998723              | 24                 |   18         | 12%         | 37.5
  992351              | 32                 |   25         | 0           | 57
  </code></pre>