Revision
So you think you can count
Round and other functions
15. Precision with round
Revision and practice

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 decimals 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.

Stuck? Here's a hint!

Here, you'll need round(account_balance,1).

Console

Code editor

Result

TableConsole