Introduction
3. The Slogan table
Concatenation
Simple text functions
How to modify Strings
Summary

Instruction

Finally, let's look at the third table.

Exercise

Select all columns from the Slogan table. For each record, we have:

  • an identifier (the Id column),
  • a reference to the related item (the ItemId column),
  • the best medium for the slogan (e.g. TV, Internet, or radio—the Type column),
  • the slogan itself (the Text column),
  • and the Id of the copywriter who wrote that slogan (the CopywriterId column).