Which merchandise item(s) had the highest total sales during the first three months of 2007 (i.e., January 2007, February 2007, and March 2007)? Display ItemID, Description, total sales generated, and the average Sale price for this merchandise item(s) with appropriate column names. (Note - Please refer to the Sale, SaleItem, and Merchandise tables; total sales is sum of sale price multiplied by quantity.)

 

Transcribed Image Text:

Customer (PetStore) ~|||||| 8 Custome Phone First Name LastName Address ZipCode CitylD ZpCode CityID City (PetStore) CRYID ZpCode City State AreaCode Population 1990 Population1980 Country Lattude Longitude Supplier (PetStore) * SupplerID Name ContactName Phone Address AnimalOrderItem (PetStore) OrderID AnimeD Cost Animal (PetStore) Animal Name T 3- Category Breed DateBorn Gender Registered Color List Price Photo ImageFle ImageHeight ImageWidth LOO Sale (PetStore) …. SaleID SaleDate EmployeelD Customer D Sales Tax Employee (PetStore) EmployeeID LastName ReceiveDate Supplier ID Shipping Cost Employee First Name Phone Address ZipCode CityID TaxPayerID DateHired DateReleased Manager D EmployeeLevel AnimalOrder (PetStore) * OrderID Order Date Title Breed (PetStore) Category Breed SaleAnimal (PetStore) SaleID Animall Sale Price Category (PetStore) Category Registration MerchandiseOrder (PetStore) PONumber Order Date ReceiveDate Supplier ID EmployeeID Shipping Cost OrderItem (PetStore) PONumber RendD Quantity Cost Merchandise (PetStore) ItemID Description QuantityOnHand List Price Category SaleItem (PetStore) SaleID Item Quantity SalePrice Customer (PetStore) ~|||||| 8 Custome Phone First Name LastName Address ZipCode CitylD ZpCode CityID City (PetStore) CRYID ZpCode City State AreaCode Population 1990 Population1980 Country Lattude Longitude Supplier (PetStore) * SupplerID Name ContactName Phone Address AnimalOrderItem (PetStore) OrderID AnimeD Cost Animal (PetStore) Animal Name T 3- Category Breed DateBorn Gender Registered Color List Price Photo ImageFle ImageHeight ImageWidth LOO Sale (PetStore) …. SaleID SaleDate EmployeelD Customer D Sales Tax Employee (PetStore) EmployeeID LastName ReceiveDate Supplier ID Shipping Cost Employee First Name Phone Address ZipCode CityID TaxPayerID DateHired DateReleased Manager D EmployeeLevel AnimalOrder (PetStore) * OrderID Order Date Title Breed (PetStore) Category Breed SaleAnimal (PetStore) SaleID Animall Sale Price Category (PetStore) Category Registration MerchandiseOrder (PetStore) PONumber Order Date ReceiveDate Supplier ID EmployeeID Shipping Cost OrderItem (PetStore) PONumber RendD Quantity Cost Merchandise (PetStore) ItemID Description QuantityOnHand List Price Category SaleItem (PetStore) SaleID Item Quantity SalePrice

Answer rating: 100% (QA)

Qry1 As you need to list the customer name we have did the concatination of customer firstname and last name to form customer namecityid joined with city table to fetch the city name and the stateto g... View the full answer