This may seem like a hard question to understand; I'm brand new to any types of coding and scripting and therefore I cannot explain this better than I have, sorry :)
I have been tasked with writing and executing a query for the following requests: "Output the sales order ID, order date, subtotal, and the tax amount increased by 2.5% for each sales order." That last section is where the problem arises. I have been able to bring up a super simple table by just entering:
SELECT SalesOrderID, OrderDate, SubTotal, TaxAmt
You need to add like this.
SELECT (TaxAmt * 1.025) as tax