129k views
0 votes
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, "John S.") The second column, Phone, is the VendorPhone column without the area code. Only return rows for those vendors in the 559 area code. Sort the result set by first name, then last name.

User Delrog
by
4.9k points

1 Answer

4 votes

The answer & explanation for this question is given in the attachment below.

Write a SELECT statement that returns two columns based on the Vendors table. The-example-1
User Hetsch
by
4.8k points