What were total sales in october

Reference no: EM13320603

Retrieve the S&S In-Chapter Database (in Microsoft Access format) from the text's Web site (or create the tables in Table 4-5 in a relational DBMS product). Write queries to answer the following questions. Note: For some questions, you may have to create two queries-one to calculate an invoice total and the second to answer the question asked.

* a. How many different kinds of inventory items does S&S sell?

* b. How many sales were made during October?

* c. What were total sales in October?

* d. What was the average amount of a sales transaction?

* e. Which salesperson made the largest sale?

* f. How many units of each product were sold?
* g. Which product was sold most frequently?

Can you please send me a copy of the actual database file you used to get your screen shots from.

Reference no: EM13320603

Questions Cloud

What emf is induced in the smaller loop : A small circular loop of area 2.00cm^2 is placed in the plane of, and concentric with, a large circular loop of radius 1.00m. What emf is induced in the smaller loop at t=0.500s

Determine what is the average shear stress in the oil : Two parallel plates, one moving at 4m/s and the other fixed, are seperated by a 5mm thick layer of oil of specific gravity 0.80 and kinematic viscocity 1.25 X 10^-4 m2/s.

What is the probability of committee composed by two mean : What is the probability of the committee composed by two mean

What height does the landing craft attain : After staying on Penitgy for a few days, the landing craft returns to its mothership. What height does the landing craft attain during this time period

What were total sales in october : Retrieve the S&S In-Chapter Database (in Microsoft Access format) from the text's Web site (or create the tables in Table 4-5 in a relational DBMS product).

Determine the distributed loading that acts along the purlin : If the purlins are spaced 4 ft and the bents are spaced 25 ft apart, determine the distributed loading that acts along the purlin DF and the loadings that act on the bent at A,B,C,D, and E.

What is the age of the ancient site : After a plant or animal dies, its 14C content decreases with a half-life of 5730 years. If an archaeologist finds an ancient firepit containing partially consumed firewood, what is the age of the ancient site

What is the half-life of this material : After 2.02 days, the activity of a sample of an unknown type radioactive material has decreased to 88.2% of the initial activity. What is the half-life of this material

Find the speed of transverse waves on this string : One of the 61.0cm -long strings of an ordinary guitar is tuned to produce the note B3 (frequency 245 Hz) when vibrating in its fundamental mode. Find the speed of transverse waves on this string

User Account

All Pages