So I've been working on something in the background for a few weeks now. One of the most requested challenge types was using Window functions, but people really struggled with them so I'm building out a complete deep dive on them, which I'll be releasing in early April.
But before I dive much deeper into it I need to get some feedback from the community.
You can find the questions here at this link:
Thanks for the help!
Dan
There were a few hiccups here and there with files not downloading or answers not being accepted, etc. As a programmer I know these things happen so I won't belabor it.
But for the next go-around, I would love to see more difficulty! Day 24 having "beginner" difficulty, small data sets and no hang-ups was a bit of a let-down. I actually implemented the wrong query and still got the right answer on accident!
Several of the challenges required implementing things like multiple sort keys, but then the data didn't have any ties to require those sort keys. Some of the "Advanced" questions boiled down to like 4-5 lines in the solution threads.
Look at Day 14, for example, where we have a pretty complex data set and are only asked to parse one date value out of json. A more complicated ask with the same basic data set would be something like "find all the items currently at the drycleaner and the next 3 dates where at least 5 items can be picked up in a single trip" or "find all the pieces of santa's green suit outfit (coat, hat, pants, suspenders, boots, etc), and the earliest weekend day they can all be picked up since santa can only go on the weekends", or "Judging by past receipts, which items take the longest time to launder and when is the best estimate for when the green suit can be picked up based on historical trends?"
I also would have loved to have seen data sets be reused between days so we can get more familiar with them, and more tables to join so we can explore more join operators.
It may sound like I'm complaining but I want to be very clear: I loved this and I want more of it.
You can now add requests for new features, bugs, improvements, and challenge types.
Check it out here:
It should also be in your drop down menu on the top right.
