Reviewing SQL and numbers
So you think you can count
Round and other functions
Instruction
Good. You can also join numbers and text values using the concatenation symbol ||. Take a look:
SELECT 'Your character is at level ' || level AS sentence FROM character;
Quite simple, as you can see.
Exercise
For each character above the first level (level > 1), show the following text:
The account balance for {name} is {money}.
{name} is the
name of the character and
{money} is the current
account_balance. Name the column
sentence.
Stuck? Here's a hint!
Use the concatenation operator || a few times and don't forget about the final period.
