Hanakkuh of Data
A database puzzle** WARNING: SPOILERS AHEAD **
** SPEEDRUN **
The SpeedRun wasn't a whole lot different than the original run through. There was a new, slightly more complex dataset, but the problems were almost exactly the same.
** PART 0 **
The code to unlock the files was the same as the previous set.
** PART 1 **
This one was also the same, but with the new data, it returned a different person to seed the rest of the problems with.
** PART 2 **
This one was also very similar, but the initials of the Contractor were different. There was also a slight change in the product SKUs that neded to be applied.
** PART 3 **
Since the person from the previous query changed, we had to change that value in the speedrun query. It also changed the birthdate of the Neighbor, so that required a couple of seconds of Google-fu to find dates for Libras in The Year of the Goat.
** PART 4 **
This one didn't require any changes. It pulled up different results, but otherwise was the same as the regular queries.
** PART 5 **
I had to run this one twice. This was the only one that I missed on the first try. I didn't catch that the Cat Lady was no longer in "Staten Island". My initial try gave me the wrong person, but when I removed that condition, I got the correct answer.
** PART 6 **
This one required no changes. I just returned a different person who was used in Part 7.
** PART 7 **
This one took me the longest of all of these. The data changes required me to make a few additions to the query. I changed the customer.id in the WHERE filters and added two new SKUs (HOM and TOY). There was an issue with my JOIN condition where I spit out the colors, but removing that condition gave me the right answer. Since color was such an important part of the original query, I'm guessing that this condition was probably intended, but I got lucky with my query. I'll take another look at this one, but for now, I've got the right answer.
** PART 8 **
The final question once again didn't require any changes.
The Speed Run was also pretty fun, but since the questions were essentially the same, not a lot of figuring was required for the queries. I don't know if that just means the data wasn't that much different or that I just wrote the queries originally that caught issues that were introduced in the speed run.
It took me 31 minutes to complete, and I only had one wrong answer in Part 5.
BACK TO PART 1
BACK TO PART 2
BACK TO PART 3
BACK TO PART 4
BACK TO PART 5
BACK TO PART 6
BACK TO PART 7
BACK TO PART 8
No comments:
Post a Comment