Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #164: Retail Therapy

JP_SDAK
8 - Asteroid

I had some discrepancies from answer; namely 1119 and 964, but left them in.  It was bugging me, so I checked the solution;  it's taking the average rating with just clothing_id, then joining the average rating back with unique clothing_id to pick up the rest of the fields.  The problem is, it's joining the unique id's before the filter for Positive Feedback Count >=10 so it's joining a clothing_id, with the incorrect Class Name (Jacket) .  If you join after the filter, you get the same answers I got.

Spoiler

JP_SDAK_1-1613498963117.png

 

 

jeremyhaber814
7 - Meteor

#164

vikb03
8 - Asteroid

Great, quick challenge! I took a similar approach to others here

 

Spoiler
vikb03_0-1614006341537.png

 

binuacs
20 - Arcturus
Spoiler
binuacs_0-1614238747554.png

 

apathetichell
18 - Pollux

My solution...

Toons
12 - Quasar

My solution :

 

Spoiler
Toons_0-1614376058882.png

 

rcarog
8 - Asteroid

Solution attached.

Luke_C
17 - Castor
Spoiler
Challenge164.PNG

Rhys1
8 - Asteroid

My solution

Eilean_
8 - Asteroid

RT