question archive 1) Write a vendorscontactvendorContactFNamevendorContactLNamephonevendorPhone SELECT statement that returns two columns based on the table
1) Write a vendorscontactvendorContactFNamevendorContactLNamephonevendorPhone SELECT statement that returns two columns based on the table
Subject:StatisticsPrice: Bought3
1) Write a vendorscontactvendorContactFNamevendorContactLNamephonevendorPhone SELECT statement that returns two columns based on the table. The first column, , is the vendor contact name in this format: , followed by a space, followed by the first letter of , followed by a period. (for example: 'Steven' and 'Smith' would be: 'Steven S.' The second column, , is the without 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)
