Answer 1

You can subtract them within the SELECT statement ex: SELECT (bal - qty) AS field1
The () are required or else it will only select the first field it comes across