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

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.