Hide Assignment Information
Instructions
Use the Chapter 4 Relational Database (in Microsoft Access format) attached to write queries to answer the following questions. The file with the solved queries should be uploaded to Brightspace in this section. Query 1: List Customers that live in the city of Winslow. Provide CustomerID, Customer-Name, and Street. Query 2: List all sales for which SalesPerson B. Green was responsible. Provide SalesInvoiceID, SaleDate, CustomerID, and CustomerName. Query 3: List all inventory items sold to Lola Doyle. Provide SaleDate, ItemID, Description, and Quantity. Queries with aggregate functions: Query 4: How many sales were made during October? Use NumOfSales as the name of your output column. Query 5: List the total of each invoice. Compute this by summing Quantity times SoldPrice for all the items on each invoice. Name the total InvoiceTotal. Provide SalesInvoiceID, SaleDate, SalesPerson, and InvoiceTotal. Sort the list by InvoiceTotal in descending order.