Challenge #459: Fun Facts About LEGO® Sets! Part 1

[claw7444]

Here is my reply 

[Nick_Tondra]

Thank you!

[brandon_bunney]

sets counted

[Sandy_Wlodarczyk]

Spoiler

[arihant_jain]

It uses Data Preparation and Transformation for solution.

Step1: Sort the dataset on "Num_parts" and sample the top 1. After that you can join with theme dataset to find the theme as well.

Step2: Merge the datasets on themeID. Group the dataset on Theme and aggregate the "Set_Num" and sort the results

Step3: Group the dataset on Year. Aggregate the "Set_Num" count, Average of "Num_parts" and Sum of "Num_parts"

[mKennedy3]

My solution!

[jamaldub1]

Brick by Brick

[a-gonzalez]

Spoiler

[Amy_smart]

Here is my solution. 

[MadYX]

I learned a lot about LEGO!