DB Module 6 Lab E

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

• List all the contents of the customer table.
• List the first name and last name of all customers that live in Hunt Valley.
• Provide the complete mailing address for all customers with the last name Smith.
• Show the Transaction dates for customer 2.
• List the last name, first name and zipcode for all customers with a last name starting with W.
• List the name of all bouquets priced at $39.99 or over.
• List the name of all bouquets that are priced at $29.99.
• List the name and price for all bouquets priced under $79.99
• List the first name and last name for all customers without phone numbers.
• List the customer id for all customers who ordered item 7.

CUSTOMER: see image.

FLOWER: see image.

ORDER: see image.