title: SQL to calculate a %
body: <p>I have the following <strong>2 columns</strong>: </p>
  
  <p>1) transaction_amount = <strong>$48.15</strong></p>
  
  <p>2) merchant_commission = <strong>10%</strong></p>
  
  <p>And I need to calculate the 2 columns below, which is a 60/40 split of the 10% commission above (6% and 4%).</p>
  
  <p>Currently, I do the following manual calculations:</p>
  
  <p>3) commission_split 1 = <strong>0.04</strong> x 48.15 (which is the transaction_amount above)</p>
  
  <p>4) commission_split 2 = <strong>0.06</strong> x 48.15 (which is the transaction_amount above)</p>
  
  <p>I'm looking for the query that makes this calculation automatically for each of the commission splits.</p>