Autumn Offers - hours only!Up to 80% off on all courses and bundles.-Close
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)