Question II9: Identifying data discrepancies given guidance
- Prompt: Orders can have the SubTotal calculated three ways:
A) From the SalesOrderHeader
B) Sum of OrderQty*UnitPrice
C) Sum of OrderQty*ListPrice
The calculation of C may often be higher than A or B because of discounts - call the ratio of A to C "Discount Rate". A and B, however, should always be the same.
Give me an export of every Sales Order where A and B are NOT the same. In the result, include the Discount Rate, Sales Order ID, and all 3 versions of the Subtotal.
- Category: Insight Identification
- Datasets: AdventureWorks
Latest Results
Tool |
Score |
Timestamp |
Video Recording |
unsupervised |
0 |
June 28, 2024 - 1:48AM |
|
ChatGPT |
5 |
July 10, 2024 - 05:54 PM |
Video Unavailable
|