I need your help in BigQuery. I'm trying to do CASE WHEN using several conditional within the same field. Here's the data:

[![CASE WHEN within the same field](https://i.stack.imgur.com/iZA7H.png)](https://i.stack.imgur.com/iZA7H.png)

In this case I wanna have one aggregated output that says TRUE when 'Resurrected' movement\_type happens AFTER 'Churned' movement\_type based on its month\_key (regardless of the gap in between them).

So, from that data I want the output to be:

```
+----------+-----------+
| group_id | condition |
+----------+-----------+
| A12345   | TRUE      |
+----------+-----------+

```

I've tried using LEAD but had no luck finding the right answer. Thank you.