Chad Callihan gets the lead out:
Imagine we want to find gaps in post history for users. If a user is posting every day, we’re happy and can assume they’re happy. If they’re only posting once every few weeks, we want to investigate why that is.
Read on to see how you can do this with the LEAD() function.