I have been asked to modify my query to identify accounts that have a credit balance > $500, but also where the balance is 12 times the monthly service rate. I've limited the amount of records coming back by simply adding a where clause > $500
where curr_balance < -500
However, I'm a little unsure as to how I would add the parameter to identify accounts in which the balance is 12 times the monthly rate. Would I be able to use a simple multiplication calculation? Such as:
where curr_balance < -500 and curr_balance > (12 * monthly_rate)
Also, if I am able to use the above formula, how do I write it so the code understands what I'm asking when the monthly rate is a positive number, however, the current balance number is negative? I.e. the current balance is $(1,200), but the monthly rate is $150. Any help is greatly appreciated! Thank you!