Reference no: EM133248315
Use Access Create Query (Query Design) to join Customers to Purchases (on CustomerID), and Purchases to Products (on ProductID), and answer the following questions:
a. Create a query that returns all the purchases from customers from Nevada (NV)?
Which fruit do people from that state seem to prefer?
b. How many pears have been sold? (Click on Totals in the Design Ribbon to bring up options to report grouped totals. Your query should Group By ProductName.
Include the Quantity field, and in the Total row, select Sum for Quantity.)
c. How many watermelons have been sold?
d. List all the states your customers come from, and the number of customers from each one. (Use COUNT under the CustomerID field from Customers.)
From which state do most of your customers come?
4-50. List the countries your customers come from, sorting the data by CountryName.
- What problem do you encounter?
- What would you do to the database to improve your ability to analyze the data by country?