Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Standard SQL Functions

Introduction
Concatenation
6. Concatenation operator || further practice
Simple text functions
How to modify strings
Review

Instruction

Good job. By the way, don't forget about tiny details such as spaces and periods when you create sentences in this way. It's easy to overlook them!

Now, get ready for the next exercise.

Exercise

For each slogan, show the following sentence (name the column: sentence):

The copywriter of the slogan with ID X is Y Z.

In this sentence, X is the id of the slogan, and Y and Z are the first and last name of the copywriter, respectively.

Stuck? Here's a hint!

Use || six times and remember to put spaces and a period in the correct places.