Tidying up WINDOW functions in BigQuery with named windows

So, if you ever find yourself working with multiple window functions in BigQuery, leverage the named windows specification for tidier, leaner code. Say you have a function like: DENSE_RANK() OVER (PARTITION BY country ORDER BY hire_date). You can ext...