Exercise

Bottom Coding

Previously, you learned about Top Coding (another anonymization method), where values that were greater than $165,000 were converted to $165,000. In this exercise, you will be applying Bottom Coding, where values that are less than $45,000 will be converted to $45,000.

Instructions

100 XP

Bottom code the salaries to 45,000.
Filter the salaries that are less than or equal to 45,000 to see how many rows were affected.

Take Hint (-30 XP)