Applied the created query in the application for testing the modified computation to get the correct net sales if there are transactions with vat exempt, tested the modified application, as per testing, the value returned is incorrect, check the computation to see why it returned incorrect total compared to the expected value.