Review
So you think you can count?
Rounding functions and more
Instruction
Good. You can also join numbers and text values using the CONCAT() function. Take a look:
SELECT
CONCAT('Your character is at level ', Level) AS LevelInfo
FROM Character;
Quite simple, as you can see.
Exercise
For each character above level 1, show the following text:
The account balance for NAME is MONEY.
where NAME is the name of the character and MONEY is the current account balance. Name the column AccountInfo.
Stuck? Here's a hint!
Use CONCAT(), and don't forget about the final period.
