Instructions: Use select statements to create queries that answer the following questions. Only provide the information requested. Do not provide the output. All tables are provided below. Use notepad or notepad++. Submit your answers in a .txt file. Do not use Microsoft Word. 1. List all the contents of the customer table. 2. List the first name and last name of all customers that live in Hunt Valley. 3. Provide the complete mailing address for all customers with the last name Smith. 4. Show the Transaction dates for customer 2. 5. List the last name, first name and zipcode for all customers with a last name starting with W. 6. List the name of all bouquets priced at $39.99 or over. 7. List the name of all bouquets that are priced at $29.99. 8. List the name and price for all bouquets priced under $79.99 9. List the first name and last name for all customers without phone numbers. 10. List the customer id for all customers who ordered item 7. + + + + 7 Torey CUSTOMER Customer Customerid - FirstName - LastName - Sally Smith 2 Karen Walters 3 Thomas Williams 4 Cecilia Jamil 5 Bryan Henley 6 Thomas Wright Watson 8 Sam Gonzales + 9 Robert Paisley 10 Katura Jimenez 11 Tammy Knott 12 Josh Franz 13 Michele Savarese + 14 Scott O'Leary 15 Tyler Hawkins 16 Sonya Patel 17 Karen Helfrich 18 Scott Abrams + 19 Susan Geaney on navirl tenner StreetAddress City - State 2601 Holly Court Baltimore MD 46 Tealeaf Road Baltimore MD 243555 Ambermill Stree Frederick MD 18 Cochoran Way Frederick MD 1 Ocean Street Frederick MD 34 Ridge Road Apt. 3 Frederick MD 675 Broad Street Bel Air MD 16 Rossville Blvd Baltimore MD 46 Greenwood Circle Edgemere MD 8 Tiger Lane, First floor Baltimore MD 2344 Wise Avenue Baltimore MD 16 Silver Spring Road Baltimore MD 501 Boston Street Baltimore MD 451 Painters Mill Road Owings Mills MD 512 Blythe Court Apt B Columbia MD 9948 Beaver Dam Road Hunt Valley MD 4 Liberty Road Randallstown MD 5130 Wilkens Ave Baltimore MD 45 Cockeysville Road, Aj Hunt Valley MD 675 Grand Cental Avenu Owings Mills Mn ZipCode Phone Numbe - Click to Add 21228 4108695532 21236 4102568831 21703 21702 21705 4435109733 21702 4104512394 21014 4435453311 21237 7814223451 21219 3016775444 21222 21222 4107662301 21236 21224 4106753814 21117 21045 6175446300 21031 4432109777 21133 4107665511 21228 3012771007 21031 4439912397 21117 4427664519 17 + + FLOWER EE! Flower Itemid + + + + + + + Item Description Red Rose Long Stem Individual 2 Red Rose Long Stem Dozen 3 Red and White Rose Bouquet 4 Bouquet- Roses Valentines Day 5 Bouquet- Mother's Day Small 6 Bouquet- Mother's Day Medium 7 Bouquet- Mother's Day Large 8 Bouquet-Apology-Small 9 Bouquet-Apology- Medium 10 Bouquet-Apology-Large 11 Bouquet-Birthday Mix 12 Bouquet - Holiday 13 Bouquet-All Occasion 14 Bouquet- All Occasion with Vase 15 Bouquet- All Occasion with Teddy Bear 16 Bouquet- All Occasion with Teddy Bear and Vase Price - Click to Add $5.99 $40.99 $38.99 $45.99 $29.99 $49.99 $69.99 $19.99 $39.99 $99.99 $25.99 $29.99 $29.99 $39.99 $39.99 $49.99 + + + + + + + + ORDER Itemid Order Orderld - Customerld 6 2 12 NI 3 NNN 4 5 7 6 15 7 3 1 8 N 9 10 11 12 13 14 6 10 19 7 6 1 14 20 Transaction Date - Click 2 1/15/2014 1 1/16/2014 10 1/16/2014 6 5/1/2014 7 5/1/2014 7 5/2/2014 5/11/2014 2 5/12/2014 1 5/12/2014 15 5/16/2014 11 5/27/2014 10 6/1/2014 1 6/1/2014 16 8/1/2014 8/8/2014 9 8/8/2014 14 8/12/2014 8/16/2014 11 8/30/2014 9 8/30/2014 15 8 16 4 17 18 16 3 5 1 19 20 17