Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 7

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Audits

Authors: Arthur E Cutforth

1st Edition

1017097445, 978-1017097443

More Books

Students also viewed these Accounting questions

Question

6. Explain the strengths of a dialectical approach.

Answered: 1 week ago

Question

2. Discuss the types of messages that are communicated nonverbally.

Answered: 1 week ago