Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I just need number 4 down through 10 there ARE NO table below Lab 6 SELECT Queries Instructions: Use select statements to create queries that
I just need number 4 down through 10
there ARE NO table below
Lab 6 SELECT Queries 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. 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. Lab 6 SELECT Queries 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. 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 7Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started