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

[RWvanLeeuwen]

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

Spoiler

Spoiler

[omercado05]

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

[Brian_Stoffel]

Fun challenge on whales.

[treepruner]

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

[luisalfonsoperez]

This is my solution

Spoiler

[KaneG]

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

[dlopez13]

Quick and easy!

Spoiler

[Wasim]

Good fun! Enjoyed this one...

Spoiler

[shock7772]

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

[Carlithian]

Here's my solution

Spoiler