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
Get step-by-step solutions from verified subject matter experts
