Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Machine Performance Modeling Methodologies And Evaluation Strategies Lncs 257

Authors: Francesca Cesarini ,Silvio Salza

1st Edition

3540179429, 978-3540179429

More Books

Students also viewed these Databases questions