Question: Write SQL statement that returns ONE column named Contact_Customer from the Customers table. This column should include customer ID, customer first name and customer last

"Write SQL statement that returns ONE column named Contact_Customer from the Customers table. This column should include customer ID, customer first name and customer last name. Please format the column as follows: customer ID, colon, space, first name, space, last name (e.g., 17: Paula Wilson without the quotation marks). Please note that the data type of the customer ID is number and need to be converted to 'character' data type. The result should be sorted by customer last name in descending order. Using substr and 'in', filter the result to include only customers whose last name begins with the letter A, B, C, or F. Then make a new statement using 'like' instead of 'substr' and 'in'. " I am at a loss on how to use substr and in properly as well as like in place of the two.

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!