Hello, I am using SQL AdventureWorks database and have to answer the following multi-part question, but I am at a loss of which AdventureWorks table fields are needed in the query to get the desired result after it has been run in SQL. I beleive this is a computer science question, but it may also be business operations management. Any help would be greatly appreciated.

Attached below are the table structures from AdventureWorks, and instructions provided by my instructor that he claims provides all the necessary information. Any help

1. Identify most and least profitable products, subcategories, and categories for retail and wholesale customers by executing a query.

PurchaseOrderDetail (F Customer (Sales) ProductModel (ProducProductDut Accountbr owguid Quantty ader (Sales) SpecialOfferProduct (S SalesT rritory (Sales) Sales OrderDetail (Sales) TransactionHistory (Production) TaxAme Product (Production) PurchaseOrderDetail (F Customer (Sales) ProductModel (ProducProductDut Accountbr owguid Quantty ader (Sales) SpecialOfferProduct (S SalesT rritory (Sales) Sales OrderDetail (Sales) TransactionHistory (Production) TaxAme Product (Production)