Review
So you think you can count?
Rounding functions and more
Instruction
Good! There is also another version of round, which takes two arguments: ROUND(x, precision). The second argument is new and specifies the number of decimal places to be returned. For example,
SELECT ROUND(136.123, 2);
will return 136.12. Let's try it out.
Exercise
Show each character's name, its actual account_balance, and the account balance rounded to a single decimal place as the rounded_balance column.
Stuck? Here's a hint!
Here, you'll need this expression: ROUND(account_balance, 1).
