I'm sure Oracle's analytic functions can handle this, but I'm having a hard time wrapping my head around the syntax. If anyone has another solution, I'd be happy to hear it too.Here's a sample ...