Rainbow Deals - hours only!Up to 80% off on all courses and bundles.-Close
So you think you can count?
Rounding functions and more
Review and practice
26. Exercise 4


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


Show each player's first name and last name (in one string with no space between the first name and last name), and their characters' level, height (with rounded to one decimal place; name the column Height), and AccountBalance (rounded down to the nearest whole integer; name the column AccountBalance).

Filter out everyone except those players with an Ids equal to 1 or 5.

Stuck? Here's a hint!

Remember to use ROUND(column, precision) in order to round the Height.