Summer Deals - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Concatenation
Simple text functions
How to modify strings
17. Function replace – practice
Review

Instruction

Fantastic! Let's do one more exercise.

Exercise

For each slogan, show the item name and the slogan with all the periods (.) replaced by exclamation marks (!). Name the second column changed_text.

Stuck? Here's a hint!

Remember you will need to join two tables in order to get all the columns.