title: Stored Procedure without a CASE Statement
body: <p>My problem is i want to know how to write an sql statement that will <strong>increase all acounts with balances over $10,0000 by 6%, all other accounts receive 5% (without using a CASE statement)</strong>
  The table involve in the statement is account table with the following fields:
  (account_number(PK), branch_name, balance).
  Thanks in advance...</p>