Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Standard SQL Functions

Reviewing SQL and numbers
So you think you can count
Round and other functions
19. Function floor() – practice
Review and practice

Instruction

OK, that was ceil(x) which always rounds up. Next comes floor(x).

Exercise

Show each character's name together with its account_balance followed by the account_balance rounded down. Name the last column floor.

Stuck? Here's a hint!

Use floor(account_balance).