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 #361: Cross Joins at Bedtime

binuacs
20 - Arcturus
Spoiler
binuacs_0-1678145654698.png

 

TonyAndriani
9 - Comet

Pretty straightforward without needing a cross join. I spent more time replicating the output than actually finding the matches. I'm interested in seeing the solution to understand why the output has composite keys and why they are shown twice in slightly different forms.

 

Spoiler
TonyAndriani_0-1678157904903.png

 

sergejs_kutkovics
9 - Comet

My try :)

Spoiler
sergejs_kutkovics_0-1678180200684.png

 

FrederikE
13 - Pulsar
Spoiler
FrederikE_0-1678182030956.png

 

Sebastian_Chaieb2
8 - Asteroid
8 - Asteroid

I am not sure if my approach is correct, however I  have exact match 

Spoiler
Sebastian_Chaieb2_0-1678188054324.png

 

François_Rs
8 - Asteroid
Spoiler
Franois_Rs_0-1678194096140.png

 

Flo_P
9 - Comet
Spoiler
Interesting challenge but feel like there's some info missing on frames in the results.
Flo_P_0-1678199018461.png

 

ahsanaali
11 - Bolide
Spoiler
ahsanaali_1-1678199647244.png

A no Join solution for a change :) 

alacoume
8 - Asteroid

I have discovered new options on concatenete in the summarize component!

Erlina
5 - Atom

Couldn't figure out the sorting, but the desired components are all there. This took a couple of tries though to figure out. 

Spoiler
Erlina_0-1678217178794.png