Challenge #1: Join to Range

[bpiscoya]

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.

[sanjay_shinde]

Here is my solution to challenge #1

[JClinton]

Spoiler

Spoiler 

[HBenMatouk]

first good 'easy' challenge

[jatluri]

test

[jrobiso2]

Actually slightly more tricky than I expected.

[sylwia-rej]

My solution:

Spoiler

[Towers]

two solutions

Spoiler

[hang_nguyen_kpmg]

Spoiler

[JS1989]

Solution