Challenge #460: Fun Facts About LEGO® Sets! Part 2

[CeliaC_Silje]

Tbh I stuck at the last process of filtering out records that do not meet the quantity requirement.

My straightforward af brain told me to match with those records which meet the requirement, and it gets me the result of 24 records.

I was, at some point, suddenly join the records to those which does not meet requirement and it leads me to the correct output.

(I guess I am not that good at logical thinking 🌚)

[Pratheek_PJ]

My Solution :

Spoiler

[RebekaMazuchova]

Uff. I hated this so much. I couldn't get to the answer for soo long.

[martinson]

Very Nice!

[Reesetrain2]

All,

My solution, albeit, I got 36 sets including the Taj Mahal itself...

Spoiler

 

[Kilbyflow_Designer]

Done!!

Spoiler

 

[jwbtx20]

This truly was fun and challenging.  I enjoyed reading everyone's comments as well!

I wanted to pick up the themes from challenge #459 in the output so that was an additional join.

Spoiler

[Daniel_Homola]

Here!

[fmilliren]

This was fun, definitely some hidden nuances that added to the challenge. I did add one field to my output that could make or break whether or not a set is completable.

Spoiler

[rmassambane]

460