Sign inBook an interview

Joins

Window Join (wj)

Skip to 4 practice questions

Practice questions on computing moving aggregates — averages, VWAP, and inspecting the underlying lookback windows — with window join.

Practice Questions

Test your understanding with 4 hands-on questions

01Compute a Lagging Moving Average with Window Join 02Inspect the Rows Captured by a Window Join 03Compute a Lagging VWAP with Window Join 04Prepare a Table to Maximise Window Join Performance