Using the PurchaseDatabase, find the most popular products amongcustomers and chart the result using EXCEL.
Write SQL Query:
Using the PurchaseDatabase come up with a good query and chartthe result using EXCEL involving the PurchaseDatabase.
Customer PK CustomerlD OrderLine PK OrderLinelD HouseholdID Gender Product Orders PK OrderlD ProductlD rderlD hipDate ill Date UnitPrice NumUnits otalPrice PK ProductID roductName ProductGroupCode ProductGroupName InStockFlag FullPrice Calendar ustomerlD rderDate PK Date mpaignlD onth ear ay of Week PaymentType ity tate ipCode Zipcount PK ZipCode PK ZipCode PK
OR
OR