The company wants to know the most popular efficient and price effective vendor. You are required to propose a criterion/criteria to define, and write code to find the answer. Your answer must not be an empty table.

 

Transcribed Image Text:

Purchase OrderDetail 123 Purchase OrderDetaillD 123 Purchase OrderID DueDate 123 OrderQty 123 ProductID 123 UnitPrice 123 Line Total 123 ReceivedQty 123 RejectedQty 123 StockedQty ModifiedDate vVendorWithAddresses 123 BusinessEntityID Acc Name ac AddressType anc AddressLine1 nec AddressLine2 ncc City ac StateProvinceName ane PostalCode RC Country RegionName PurchaseOrderHeader 123 Purchase OrderID 123 Revision Number 123 Status 123 EmployeelD 123 VendorID 123 ShipMethodID Order Date ShipDate 123 SubTotal 123 TaxAmt 123 Freight 123 Total Due ModifiedDate Vendor 123 Business EntityID nec Account Number ABC Name 123 CreditRating 123 PreferredVendorStatus 123 ActiveFlag RDC PurchasingWebServiceURL ModifiedDate Product Vendor 123 ProductID 123 Business EntityID 123 AverageLead Time 123 Standard Price 123 LastReceiptCost LastReceiptDate 123 MinOrderQty 123 MaxOrderQty 123 OnOrderQty ADC UnitMeasureCode ModifiedDate ShipMethod 125 ShipMethodID Acc Name 123 ShipBase 123 ShipRate nac rowguid ModifiedDate vVendorWithContacts 123 Business EntityID ROC Name Roc ContactType ADC Title ROC FirstName RDC MiddleName ADC LastName ADC Suffix RDC PhoneNumber RDC PhoneNumberType noc EmailAddress 123 EmailPromotion Purchase OrderDetail 123 Purchase OrderDetaillD 123 Purchase OrderID DueDate 123 OrderQty 123 ProductID 123 UnitPrice 123 Line Total 123 ReceivedQty 123 RejectedQty 123 StockedQty ModifiedDate vVendorWithAddresses 123 BusinessEntityID Acc Name ac AddressType anc AddressLine1 nec AddressLine2 ncc City ac StateProvinceName ane PostalCode RC Country RegionName PurchaseOrderHeader 123 Purchase OrderID 123 Revision Number 123 Status 123 EmployeelD 123 VendorID 123 ShipMethodID Order Date ShipDate 123 SubTotal 123 TaxAmt 123 Freight 123 Total Due ModifiedDate Vendor 123 Business EntityID nec Account Number ABC Name 123 CreditRating 123 PreferredVendorStatus 123 ActiveFlag RDC PurchasingWebServiceURL ModifiedDate Product Vendor 123 ProductID 123 Business EntityID 123 AverageLead Time 123 Standard Price 123 LastReceiptCost LastReceiptDate 123 MinOrderQty 123 MaxOrderQty 123 OnOrderQty ADC UnitMeasureCode ModifiedDate ShipMethod 125 ShipMethodID Acc Name 123 ShipBase 123 ShipRate nac rowguid ModifiedDate vVendorWithContacts 123 Business EntityID ROC Name Roc ContactType ADC Title ROC FirstName RDC MiddleName ADC LastName ADC Suffix RDC PhoneNumber RDC PhoneNumberType noc EmailAddress 123 EmailPromotion