Question: 1)Write a SELECT statement that returns two columns based on the vendors table.The first column, contact , is the vendor contact name in this format:

1)Write a SELECT statement that returns two columns based on thevendorstable.The first column,contact, is the vendor contact name in this format:vendorContactFName, followed by a space, followed by the first letter ofvendorContactLName, followed by a period.(for example: 'Steven' and 'Smith' would be: 'Steven S.'The second column,phone, is thevendorPhonewithout the area code.Use the string functions to return only rows for vendors in the 559 area code.Sort the result set by first name, then last name.(I return 34 rows)

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 Mathematics Questions!

Please complete the following in SQL. Exercises 1. Write a SELECT statement that returns two columns based on the Vendors in this format. table. The first column, Contact, is the vendor contact name...

This is in SQL. 3. Write a SELECT statement that returns two columns based on the Vendors table. The first column, Contact, is the vendor contact name in this format: first name followed by last...

Write a SELECT statement that returns two columns based on the Vendors table. The first column, Contact, is the vendor contact name in this format: first name followed by last initial (for example,...

Write a SELECT statement that returns two columns based on the Vendors table. Contact which is a combination of VendorContactFName and VendorContactLName but only the first initial in...

.*. TIA .*. SQL 1. Write a SELECT statement that returns two columns based on the EMPLOYEES table. Contact, is the employee lastname and the first initial of the first name. The second column, Phone,...

using AP database Please create solutions to the following queries: 1. Write a select statement that returns four columns based on the InvoiceTotal column of the invoices table, Cis11101 AP database....

This is in SQL 1. Write a SELECT statement that returns four columns based on the InvoiceTotal column of the Invoices table: Use the CAST function to return the first column as data type decimal with...

Setup: Use create _ ap . sql to create database 1 . Write a SELECT statement that returns four columns based on the InvoiceTotal column of the Invoices table: o Use the CAST function to return the...

using SQL server MGMT studio and the AP database l uling Server Management Studio. Please make sure the Cis113 the ai w the SQl syntax for each query that is created question is worth 3 points if the...

Suppose that X and Y have a bivariate uniform density over the unit square: (a) Find c. (b) Find P (0 0

For Target Corporation, indicate whether the following transactions would (1) increase, (2) decrease, or (3) have no effect on stockholders equity. a. Borrowed money from the bank. b. Paid creditors....

A company may choose a skimming strategy duricg He itrobaction stage of its product to help recover costs of developenent and to A ) capitalize on the price insensitivity of early beyers. B )...

Required information [The following information applies to the questions displayed below.) Mason Corporation began operations at the beginning of the current year. One of the company's products, a...