You, as an Internal auditor, want to make sure that you received all data you requested to

Fantastic news! We've Found the answer you've been seeking!

Question:

You, as an Internal auditor, want to make sure that you received all data you requested to the IT dept.. You know that the total amount of all transactions should be $232,500. The data file you received is titled as "sales_2022".

It has the following attributes: Sales_order_ID, customer_ID, sales_date, and amount

1. Please create a SQL program to evaluate the data quality?

2. If the SQL outcome is not equal to what you expect, what can you say for the data quality? What actions should you take for the follow-up?