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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started