Reviewing SQL and numbers
So you think you can count
Round and other functions
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 together with its original account_balance and account_balance rounded to a single decimal place (name this column rounded_account_balance).
Stuck? Here's a hint!
Here, you'll need round(account_balance, 1).
