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.