Question: 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,

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.)

Customer (PetStore) ~|||||| 8 Custome Phone First Name LastName Address ZipCode CitylD

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

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 full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

As a winner of a local competition, you can choose one of the following prizes:(a) $100,000 now(b) $170,000 at the end of 4 years(c) $18,000 per year starting next year for 10 yearsWhich one is the...

Read the case study and answer the question below with a one page response. What does a SWOT analysis reveal about the overall attractiveness of Under Armours situation? Founded in 1996 by former...

During its first three months of operation, Palimino's sold gift cards in various amounts totaling $5,200. The gift cards are redeemable for meals within one year of the purchase date. Gift cards...

Create SQL query for the following question using Sally's Pet Store 1. Which employee sold the most quantity of items in March? NEED ASAP! Please help \begin{tabular}{|l|} \hline...

10. Suppose f(x) = x - 2. Use the centered difference method with h = 0.1 to approximate f'(1).

This is SQL, I need help with these statements please!!! Here is everything needed to do it: Write SQL statements for questions given below for the PetStore database. Save your SELECT statements as...

I need help on this database SQL questions refer to the table given. Thank you 1) PetStore: List all of the fist sorted by breed 2) PetStore: List all animals born in March 3) PetStore: What is the...

Please help me with this database SQL questions refer to the picture below. Thank you in advance. 1) PetStore: Which cat merchandise has a list price more than the average price of cat merchandise?...

Please help me with this database SQL questions refer to the picture below. Thank you. 1. PetStore: How many cats were sold in February 2. List the suppliers in Kentucky that sold us fish 3....

I need help on this database SQL questions refer to the table given. Thank you 1) RollingThunder: What is the profit margin for derailleurs for Road bikes. Search for derailleur in any part of the...

If you borrow $25 000 as a four-year loan from the bank at a rate of 7 percent, monthly, what is the monthly payment on this loan? compounded

Read the article Frito-Lay Inc and answer the following question: What is involved with successful branding? Explain how solid brand management and positioning would impact this product.

For the following function, g ( x ) = xsquare - 7 x - 8 ( a ) Find the values of for which . g ( x ) = 0 ( b ) Find . g ( 0 ) Express numbers using integers or simplified fractions.

A small business consultant is investigating the performance of several companies. The Fourth quarter sales for last year (in thousands of dollars) for the selected companies were: Fourth-Quarter...

1. Review the financial statements of Victor and Maria Hernandez (Table) and respond to the following questions: (a) Using the data in the Hernandezes balance sheet, calculate an investment...

The comparative balance sheets for Rothlisberger Company as of December 31 are presented below. Additional information: 1. Operating expenses include depreciation expense of $42,000 and charges from...

In 2018, internal auditors discovered that PKE Displays, Inc. had debited an expense account for the $350,000 cost of equipment purchased on January 1, 2015. The equipment's life was expected to be...

You walk up to the main entrance and remember that a identification numberis required to enter. This keypad allows for the entry of any number, including negative values.Fortunately, you remember...

Preparing a consolidated balance sheet. The first two columns of Exhibit 13.13 present information from the accounting records of Ely Company and Sims Company at the end of the current year. Ely...

Flow of manufacturing costs. Toyota Corporation, a Japanese automobile manufacturer, follows U.S. GAAP and reports its results in millions of yen (). On March 31, 2008 and 2007, Toyota reported the...

Define financial leverage. As long as a firms rate of return on assets exceeds its after-tax cost of borrowing, why doesnt the firm increase borrowing to as close to 100% of financing as it can?

=+18. Probability calculations play an important role in modern forensic science (Aitken, C., Statistics and the Evaluation of Evidence for Forensic Scientists,

=+17. Suppose that A and B are independent events with P(A) 5 .5 and P(B) 5 .6. Can A and B be mutually exclusive events?

=+15. In Exercise 5, suppose that 95% of the fasteners pass the initial inspection. Of those that fail inspection, 20% are defective. Of the fasteners sent to the recrimping operation, 40% cannot be...