Want to get involved? We're always looking for ideas and content for Weekly Challenges.
Hi there, I think the solution is reasonable since the example shows only 5 ranges. However, your current approach is not scalable.
Should the table increase the number of records, it would be tedious to update manually the code your nested case sentence.
Such assumption usually happens in real data.
Here is my solution to challenge #1
first good 'easy' challenge
Actually slightly more tricky than I expected.