The Situation: Monday Boots implemented a new tax processing system in mid-July 2017, and with most implementations of new systems, there were a few hiccups. Some orders calculated tax correctly, but the final order total wasn't correct...

Using the retail.orders table, pull all columns for orders where the final order amount is not correct. Refer back to the structure of the retail.orders table if necessary.

Want a hint?

The final_total field is equivalent to total minus discount_amount plus tax_amount. Remember that math can be done in the WHERE clause and that "not equal to" is represented by .

Want another hint?You are checking to see if final_total total-discount_amount+tax_amount.

SOL View + erderd ca completed at an promotion sortail discountament final til refundid tant 236 pad 100043 3519 20.00 191.1 ES 5001 13 2016-001001 350.00 100653 20.00 9.35 19235 10065 02 3457 5 185.00 15 100633 2000 9.00 9660 0 361-25 . 22.50 1001 13 2011-2012 200.00 13120 1001 10 302 1 * 300.00 2.00 100 5050 A DO 0.00 16 100 * 30 11 1001 13 40 * 152 100290 200.00 1002 171.6 05.04 2016012124223 SOL 1009451 . 2016012110 2016012181525 135.00 35 100 2 2320 3250 2016-12 201524 2015-02-12220512 2016-0913003422 2 . 2296 10000529 7170 2 10039393 200.00 16.4 10003310 179.00 10032900 2355 2015-09-139245 2015-09-13 04:31 2015-09-13071897 11.50 195.50 10035399 3327 10033258