Referring to the diagram above, which tables would need to be referenced in the FROM statement for the SELECT statement of "SELECT s.CustomerID, s.SaleDate, s.SalesInvoiceID, SUM(Quantity*SoldPrice) AS OrderTotal"?

Select one:

a. Customer, Sales AS s, Sale_Inventory, Inventory.

b. Sales AS s, Inventory

c. Sale_Inventory, Inventory

d. Sales AS s, Sale_Inventory

Customer CustomerlD CustomerName Street City State Sales SalesinvoicelD SaleDate SalesPerson Customer D 00 Sales Inventory SalesinvoicelD ItemID Quantity SoldPrice Inventory ItemID Description Color VendorID QuantityOnHand ListPrice