Please turn JavaScript on
header-image

Sean D. Stuber

Click on the "Follow" button below and you'll get the latest news from Sean D. Stuber via email, mobile or you can read them on your personal news page on this site.

You can unsubscribe anytime you want easily.

You can also choose the topics or keywords that you're interested in, so you receive only what you want.

Sean D. Stuber title: Sean D. Stuber

Is this your feed? Claim it!

Publisher:  Unclaimed!
Message frequency:  1.79 / week

Message History

Reactor

Part 1 is a simple recursion with limited paths, so I used CONNECT BY where the device (source) of each row is contained within the output (target) of the prior row. So, in the sample data, the line “b...


Read full story

Movie Theater

Part 1 was pretty straightforward. I extract the X and Y coordinates from each line and then using a self-join, I compare the areas of each possible rectangle. As with many other, similar, self-joi...


Read full story

Playground

This one felt tricky at first with lots of words and seemingly numerous combinations of how to arrange the boxes, but the solutions turned out to be fairly straightforward. It wasn’t necessary to reco...


Read full story

Laboratories

This one was a little misleading, but that’s probably more due to me assuming too much going in than any tricky wording. My first thought was this would be a recursion puzzle because of the tree nat...


Read full story

Trash Compactor

Like Day-5, I accepted a slight efficiency hit by reading the data twice for logical convenience. I read the numbers as one CTE and then read the corresponding operators as a second CTE.

Since the data is irregularly spaced I used regular expressio...


Read full story