Documentation: More advance KSQL examples?

[rburton]

I'm currently trying to find some examples to help me wrap my head around KSQL and how to handle various scenarios.

A few scenarios I'm curious about are:

Event Design: EventStream(user string, eventName string)

1. Detecting if multiple events happen within a current timeframe. e.g., if a user registers and updates their profile within 30 days

2. How to detect of a sequence of events occurred in order over a timeframe. e.g., a user logins then the next event is 'invite friend' within 24 hours

3. How would you detect if an event happens multiple times and another event also happened within in a timeframe? e.g., a user logins 3 times and also a forgot password event occurred.

Mentally, I struggle with how to design for these scenarios. e.g., would I have to create tables based on a timeframe and using counts and join that against a stream?

I feel like more "complex" examples would help developers better understand what KSQL do for them and also how to start composing their own custom complex queries.