Use Access Create Query (Query Design) to join Customers to Purchases (on Customer ID), and Purchases to Products (on Product ID), 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 Product Name. 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 Customer ID field from Customers.) From which state do most of your customers come?