Question: Write a query that will return a list of Vendors that have: > An 800 number > The first number of their zipcode is from

Write a query that will return a list of Vendors that have:

> An 800 number

> The first number of their zipcode is from 1 to 5

> The second number of their zipcode is from 3 to 5

> The last number of their zipcode is a 5

Include columns: VendorName, VendorPhone, and VendorZipCode

Actual output below:

VendorName VendorPhone VendorZipCode

Publishers Weekly (800) 555-1669 43305

Champion Printing Company (800) 555-1957 45225

Write a query that returns all vendors that have a PO Box. Note, there are many forms

that are listed (e.g., PO Box, P O Box, P.O. Box, etc.) so you should only look for Box.

> Exclude all records that do not have a phone number.

> Return VendorName, VendorAddress1, VendorAddress2, and VendorPhone.

> Do not show NULLs for any of the fields. You should account for NULLS being in

VendorAddress1 and VendorAddress2

> Sort the list by VendorName

First 5 rows listed below:

VendorName VendorAddress1 VendorAddress2 VendorPhone

American Express Box 0001 (800) 555-3344

BFI Industries PO Box 9369 (559) 555-1551

Blue Cross PO Box 9061 (800) 555-0912

Blue Shield of California PO Box 7021 (415) 555-5103

Cahners Publishing Company Citibank Lock Box 4026 8725 W Sahara Zone 1127 (301) 555-2162

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Please create a .sql file that answers the 2 questions below. Question 1: Write a query that will return a list of Vendors that have: -- An 800 number -- The first number of their zipcode is from 1...

SQL 1) Write a query that will return a list of Vendors that have: > An 800 number > The first number of their zipcode is from 1 to 5 > The second number of their zipcode is from 3 to 5 > The last...

Write a query that will return a list of all customers and their invoices. Return only rows where invoices were created by a user who never contacted that particular customer. For each row, return...

In this question assume that p and q are atomic formulae. (a) Compare and contrast path formulae and state formulae in temporal logic. [4 marks] (b) Describe and contrast the meanings of F(G p) and...

Please help write a single script (with comments at the top) Make sure you PRINT each question before you write the query to SELECT the results. 7. Create a query to determine the number of sections...

1. (Use AP) Write a SELECT statement that returns six columns from three tables, all using alias names: VendorName column named Vendor, InvoiceDate column named Date of Invoice (include the spaces),...

A. Write a query that returns three columns from the Vendors table: vendor_name, vendor_contact_last_name, and vendor_contact_first_name. Sort the results by last name and then by first name. B....

SQL Databases A) (10 rows) Write the query that returns records 11-20 from the Vendors table when sorted by VendorName B) (? rows) Write the query that doesn NOT use a JOIN that returns all columns...

Please help write a single script (with comments at the top Make sure you PRINT each question before you write the query to SELECT the results. List the salutation and names (first and last name) of...

Agri Bank (South Africa) took up a Eurocurrency loan of US$1 000 000 for 180 days at 2.50% per annum from Naomigroup, Washington, United States of America. The spot exchange rate ZAR/US$ = 17.27, the...

November 1, 2020, 5M Corporation entered into a purchase contract (not subject to revision or cancellation) to purchase 500 units of inventory for $50 per unit before January 1, 2021. The company...

2. Identify the factors that are relevant in determining the annual depreciation charge, and explain whether these factors are determined objectively or whether they are based on judgment.

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

=+1. Give three examples of important trade-offs that you face in your life.

=+Why is a country better off not isolating itself from all other countries?

=+ 3. Water is necessary for life. Is the marginal benefit of a glass of water large or small?