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

uk_msmt
8 - Asteroid

Here is my solution. I don't think this is the best way though.

Spoiler
uk_msmt_0-1611672038257.png

 

Slacker
8 - Asteroid

My solution

PHinkel
7 - Meteor

Hi,

 

Attached is my solution.

danettedavis
8 - Asteroid

solved

i_love_databases
8 - Asteroid

I have to do something similar but with in-db. The original query uses a "between" join operator..


I plan to do a cartesian product then filter; since there is no generate rows in in-db and no possibility to use a between join operator.

Best regards

manny890-
7 - Meteor

My Solution:

iqkh76
5 - Atom

My solution 😀 

 

Spoiler
iqkh76_0-1612722881179.png

 

Fynn
6 - Meteoroid

study the function,do my job 

AviratG
6 - Meteoroid

Tools Used: Formula, Join, Summarize

aluthra
8 - Asteroid

Nice to see the real-world use of generate rows tool. Enjoyed solving the challenge.