We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Use of Round is improper here since it rounds Up in cases where decimal values are >= 0.5. Floor should be used instead since we're asked to round Down. Note that with MS SQL Server, when averaging an Integer such as the Population field, the average function does not cause implicit conversion to Float so decimal values are ignored and applying Floor is unnecessary.
Average Population
You are viewing a single comment's thread. Return to all comments →
Use of Round is improper here since it rounds Up in cases where decimal values are >= 0.5. Floor should be used instead since we're asked to round Down. Note that with MS SQL Server, when averaging an Integer such as the Population field, the average function does not cause implicit conversion to Float so decimal values are ignored and applying Floor is unnecessary.