Use the Chapter 4 Relational Database (in Microsoft Access format) attached to write queries to answer the following questions.

Query 1: List Customers that live in the city of Winslow. Provide CustomerID, Customer-Name, and Street. Query 2: List all sales for which Sales Person "B. Green" was responsible. Provide SalesInvoiceID, SaleDate, Customer ID, and CustomerName. Query 3: List all inventory items sold to "Lola Doyle". Provide Sale Date, 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 Invoice Total. Provide Sales InvoiceID, Sale Date, Sales Person, and Invoice Total. Sort the list by Invoice Total in descending order.