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


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.


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