Objective: Enhance the customer table by adding a new field labeled “spending_category.” Using the aggregate data from challenge #7, categorize each user as a low, medium, or high spender based on these criteria:
Low Spender: Customers spending less than $341.01
Medium Spender: Customers spending between $341.02 and $644.91
High Spender: Customers spending more than $644.91
Note: Make sure to upload the CSV files provided and set up your tables as described in challenge #6. This is essential for everything else we'll be doing.
Expected Result: The customer table should be updated to include a new field labeled spending_category. Each customer must be categorized as either a low, medium, or high spender within this field based on the specified criteria. The expected result is case-sensitive. Make sure your spelling matches the example in the image above.
Once you are done, make sure to submit the integer 1 as the result to mark this challenge complete.
challenge_id: 8