filtering

The Kalman filter is optimal Bayesian tracking under linear-Gaussian assumptions, and it amounts to two steps repeated forever. The signal is explaining what the gain trades off and when the assumptions break. Here is the answer.

WHERE cannot reference a window function, so people resort to wrapping queries in subqueries. QUALIFY filters on window output directly. The signal is explaining why WHERE fails and writing top-N-per-group cleanly.