Question: Write a SELECT statement that retyurns these columns from the vendors table: the vendor_name column the vendor_name column in all capital letters the vendor_phone column

Write a SELECT statement that retyurns these columns from the vendors table:

the vendor_name column

the vendor_name column in all capital letters

the vendor_phone column

A column that displays the last four digits of each phone number

When you get that working right, add these columns that follow to the result set. This is more difficult because these columns require the use of functions within functions.

the vendor_phone column with the parts of the number seperated by dots as ub 555.555.5555

A column that displays the second word in each vendor name if there is one and blanks if there isn't.

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!

Chapter 8 How to work with data types and functions Exercises 1. Write a SELECT statement that returns these columns from the Invoices table: The invoice_total column Use the TO_CHAR function to...

In SQL, 3. Write a SELECT statement that returns these columns from the Vendors table: - The vendor name column - The vendor name column in all capital letters - The vendor phone column - A column...

complete the following exercises using join syntax for my SQL... Appreciate it! presented in this chapter, this is the one you'll use most o e sure you understand it thoroughly before you go on....

Setup: Use file create _ ap . sql to create the database. 1 . Write a SELECT statement that returns all columns from the Vendors table inner - joined with the Invoices table. 2 . Write a SELECT...

help 1. This query will show the Vendors and their balance due Write a SELECT statement that shows four columns by joining Vendors and Invoices VendorName (Vendors table) InvoiceNumber (Invoices...

Description Upload a single sql file that contains all solutions prefixed with comments for the following exercises. Exercises 1. Write a SELECT statement that returns all columns from the Vendors...

CSC255 Chapter 3 Homework (You'll be creating a query for each problem. Copy and past all your queries into one text file (best to use Notepad++ for it) In these exercises, youll enter and run your...

Upload a single .sql file that contains solutions (in sql) for Chapter 3 exercises below. Prefix each solution with a comment with problem number as below: -- Solution for problem 6 - Solution for...

How to query/ write statements for exercise #4-7. See Attached Chapter How to retrieve data from a single table 1 Exercises . Write a SELECT statement that returns three columns from the Vendors...

Run the create _ ap . sql script to create the database 1 . Write a SELECT statement that returns three columns from the Vendors table: VendorContactFName, VendorContactLName, and VendorName. Sort...

Identify several controls directed at ensuring the integrity of the procurement business process.

1.) Asta, a resident of Manila, the sole proprietor, of ABC Company engaged in selling of goods in Manila. In October 2019, Asta sold goods to customers for total sales of 1,000,000 (50% was on...

Which of the following phrases is not associated with a broker - dealer acting as a market maker? A ) profits on spread. B ) trades with customers from own inventory. C ) performs the transaction on...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

2. What are some of the things Henry Ford did that you think have merit? If you were running a company, what practices of his might you adopt?

1. How did Fords approach to employee relations impact employees? Do you think it was to their advantage or disadvantage for the company to take such an active interest in their lives?

4. Increased activism in government agencies and legislatures has resulted in an expansion of worker protection laws and additional restrictions on employer conduct. These laws and restrictions...