Only this week, get the SQL Complete Track of 9 courses in a special prize of $330 $89!
So you think you can count?
Rounding functions and more
19. Numeric functions: FLOOR()
Review and practice


Okay, that was CEILING(), which always rounds up. Next comes FLOOR().


Show each character's name and actual AccountBalance, followed by the value in AccountBalance rounded down. Name the column DownBalance.

Stuck? Here's a hint!

Use FLOOR(AccountBalance).