Challenge #427: Bookstore Sales Analysis

[DataNath]

My solution to #427:

Spoiler

Used my SQL Join macro to easily handle the range join and then the rest was straightforward.

[Milanz]

my solution ;-)

Spoiler

 

[logdog0411]

Spoiler

 

I am almost certain there's a far more elegant way to accomplish this. Can't wait to look at everyone else's answers!

🪖

[ScottLewis]

This one was a good one for solving and then trying to figure out a more efficient way to solve.

This is where I ended up. I want there to be a way to do it without sorting, but the only way I see requires a rejoin, which is worse.

Spoiler

 

[fmilliren]

Spoiler

[Qiu]

Fun Challenge

Spoiler

[balajilolla2]

Spoiler

Solution Attached

[Qiu]

I also made attempt to use the Designer Cloud but strange thing is that the Join will not work for two Date Fields...

Spoiler

[jbarney]

Cool challenge!

[Anujmalikk]

Solution:-