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 #1: Join to Range

Assaf_m
11 - Bolide

Solution attached

JennyMartin
9 - Comet
Spoiler
AWC1.PNG

First weekly challenge that I've taken the time to submit! Nice and simple.

jusdespommes
8 - Asteroid

Late to the party - but all done 🙂

 

Spoiler
WeeklyChallenge1.PNG

 

arvinang
5 - Atom
 
arvinang
5 - Atom

I just started answering the weekly challenge. Thanks for creating this and sharing your solution. I also derived similar output using the attached model.🙂

_tbrown
6 - Meteoroid

My first challenge!

KT2
7 - Meteor
Spoiler
Spoiler

Boom.

Original_Yodies
8 - Asteroid

I'm a little late to the party but starting my mission to complete each weekly challenge.

NicoleNwoha
5 - Atom

Here's my solution! 

timrains
8 - Asteroid

Very late to challenge no. 1 but got to start somewhere. 

Spolier! 

 

 

 

Spoiler
 

Calculate start and end postcodes, then generate rows to create a row for each postcode, join on postcode, then sum and count distinct as per instructions. 


Week1.PNG