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 MS SQL Server

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.