Weekly Challenge

RWvanLeeuwen · ‎07-20-2020

I am reposting my solution as the leaderboard might be missing this post from my account

Spoiler

omercado05 · ‎07-20-2020

A nice and simple challenge. This was a fun one.

Brian_Stoffel · ‎07-20-2020

Fun challenge on whales.

treepruner · ‎07-20-2020

I had to add some additional sorts to get it to look like the output!

luisalfonsoperez · ‎07-21-2020

This is my solution

Spoiler

KaneG · ‎07-21-2020

Nice easy Data Analysis example. Thanks to @ArtApa, for mentioning this example for AMP engine comparison. 6.4 seconds down to 3.4 seconds by using AMP engine.

Spoiler

Use of Count Distinct in Summarise to reduce tools
I joined the small tables first, to reduce sorting speeds on the joins

Use of Count Distinct in Summarise to reduce toolsI joined the small tables first, to reduce sorting speeds on the joins

dlopez13 · ‎07-24-2020

Quick and easy!

Spoiler

Wasim · ‎07-25-2020

Good fun! Enjoyed this one...

Spoiler

shock7772 · ‎07-25-2020

If at first you don't succeed whale whale again.

Carlithian · ‎07-27-2020

Here's my solution

Spoiler

Weekly Challenge

IDEAS WANTED

Challenge #222: Where There's a Whale There's a Way