Challenge #300: Where is the party?

[monikalatos]

Here's my solution

[ekarita]

My solution

[asanorrby]

Not sure I agree on the suggested output based on the requested data samples, but here is a way to end up with the suggested output. 

[noelo]

Complete, with exception of parsing the Code_Name into separate Country Code and Country Name

[trjeffries]

Spoiler

 

[BeckyWright]

Spoiler

Spoiler

 

[thiago_santos_UK]

 

[PrzemekNabozny]

Hi,

Solution attached. Slight difference on solution 1, as result table for that exercise was not clear enough.

Spoiler