The biggest challenge at a startup that's growing quickly is how often your job changes. What matters and where your focus needs to be is always changing.

The questions to decide are:
* Where is the inflection point where ROI and effort are aligned -- aka how deep to invest
* For which functions should it be prioritized
* What does the support model look like
* What is the process for getting more help when needed

As a leader, you can't ignore it and it's impossible to universally achieve. When making consequential decisions stakeholders want consensus and a partner.

When assets exist you still have to teach new people what they're called and where to find them. Metrics have to keep up with the biz.

I'm going to cite this as evidence of how great our team is next time we get to hire, watch me.

turning your pain into art I see 😆

Which is a bummer because unless you carefully guard the inputs the recursion can run away forever!

Wait I found a solution in pure SQL using list transformations (works in DuckDB): gist.github.com/aranke/74206...

It nerd sniped our whole team in the best way! We used a recursive solution!

The Boolean is the correct answer! The challenge is to create it. I haven’t found a way to do it in SQL with lag functions but I’d love to see one!

And full confession I did not solve it