Challenge #377: Video Game Sales Insights

[i-godz]

スポイラ

[JBevan89]

Solution attached

[3I_ATLAS]

Neat Challenge!  If there's a GOD out there, please answer me why 7 records do not fully reconcile against the solution when in include the type DOUBLE Total Global Sales in the join.  There are absolutely no rounding going on and the amounts are exactly the same.  Also both L and R sides of the join have this field as DOUBLE.  Why still 10 records fail this join? 🤔

スポイラ

[EuanGriffith]

Here we go:

スポイラ

 

[blairmbailey]

Solution attached - thank you!

[jfissel]

スポイラ

[Arran]

Awesome

[mbens123]

スポイラ

 

[TomashevskiiVladimir]

 

[Saranya1995]

Here is my solution!