Summer Deals - hours only!Up to 80% off on all courses and bundles.-Close
Reviewing SQL and numbers
So you think you can count
Round and other functions
15. Precision with round()
Review 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 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).