Free Trial

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

AaronSmatta
8 - Asteroid

Interesting challenge

Reesetrain2
9 - Comet
9 - Comet

I struggled with this one and had to peak at others...

Spoiler
Capture.PNG

TheOC
15 - Aurora
15 - Aurora

Cross joins can be a headache!

Spoiler
TheOC_0-1681293110303.png


A slight change in order but the data is the same!


Bulien
CasperBuenting
7 - Meteor
Spoiler
CasperBuenting_0-1681389962209.png

 

lanclot23
7 - Meteor
Spoiler
361.png

OllieClarke
15 - Aurora
15 - Aurora

Weird desired output, but here's my solution:

Spoiler
OllieClarke_0-1681811290559.png

 

bjkay30
8 - Asteroid
Spoiler
bjkay30_0-1682688218565.png

 

elena_mazareanu
8 - Asteroid

Solved

Christina_H
14 - Magnetar

This was actually simpler without the cross-join

Spoiler
Christina_H_0-1683710763088.png

 

Alayna
8 - Asteroid

Similar to others