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

Common Functions in PostgreSQL

Review
So you think you can count?
Rounding functions and more
Review and practice
26. Exercise 4

Instruction

Well done! The final challenge is just ahead...

Exercise

For players with ID of 1 or 5, show:

  • First and last name joined by a single space as the player_name column.
  • Their characters' level.
  • Height rounded to one decimal place as the rounded_height column.
  • Account balance rounded down to the nearest integer as the account_balance column.

Stuck? Here's a hint!

You will need to use the following expression in order to round the height:

ROUND(height::numeric, 1)