Using the AdventureWorks database in SQL answer the following question:

Attached below are the Table Strucutures and ERD Diagram. If there is any other information or a different way of providing the necessary information, If you could let me know how to upload it, I will do so. I really appreciate anyone willing to try and help me solve this problem.

In a section of an MS Word document explain all of the sources (some fields are always calculated and do not have sources) you found for the following fields. LineTotal UnitPrice UnitPriceDiscount OrderOty For each of the sourced fields above write a query like described in the hint" above that explains how many ways that "source" is used to calculate the field. For example, there are multiple discounts applied to ListPrice (the source) to calculate UnitPrice. Another example, sometimes the SpecialOffer DiscountPct is ignored. In the query, identify the number of rows of Wholesale and Retail sales order details to which the calculation accounts In a section of an MS Word document explain all of the sources (some fields are always calculated and do not have sources) you found for the following fields. LineTotal UnitPrice UnitPriceDiscount OrderOty For each of the sourced fields above write a query like described in the hint" above that explains how many ways that "source" is used to calculate the field. For example, there are multiple discounts applied to ListPrice (the source) to calculate UnitPrice. Another example, sometimes the SpecialOffer DiscountPct is ignored. In the query, identify the number of rows of Wholesale and Retail sales order details to which the calculation accounts