Where does QUALIFY fit in the order of execution in BigQuery?

Here's an example of how QUALIFY fits into the order of execution in SQL. In the BigQuery example below, we want to compute the second-to-last order_updated event for each order. To do this, we filter to keep only the rows WHERE order_status = 'o...