Marcia's Dry Cleaning is an upscale dry cleaners in a well-do-do suburban neighborhood. Marcia makes her business stand out from the competition by providing superior customer service. She wants to keep track of each of her customers and their orders. Ultimately, she wants to notify them that their clothes are ready via email. To provide this service, she has developed an initial database with several tables. Three of those tables are the following:
CUSTOMER (Phone, FirstName, LastName, Email)
INVOICE (Number, DateIn, DateOut, TotalAmt, Phone)
INVOICE_ITEM (Number, Item, Quantity, UnitPrice)
Code Microsoft's Access SQL statements to produce the following information.
(i) Show all data in each of the tables.
(ii) List the Phone and LastName of all customers.
(iii) List the Phone and LastName for all customers with a FirstName of 'Nikki'.
(iv) List the Phone, DateIn, and DateOut of all orders in excess of 100.
(v) List the Phone and FirstName of all customers whose first name starts with 'B'.
(vi) List the Phone and FirstName of all customers whose last name includes the characters, 'cat'.
(vii) List the Phone, FirstName, and LastName for all customers whose second and third characters of phone number is 23.
(viii)Determine the maximum and minimum TotalAmts.
(ix) Determine the average TotalAmt.
(x) Count the number of customers