1. 학습
    2. /
  2. 강의
    3. /
  3. Introduction to BigQuery
Connected

연습 문제

Using row based WINDOW functions

Window functions often take a row-based window, looking at a number of rows before or after the current row. In this exercise, you will use the same query three times to create a row based window function.

지침 1/3

undefined XP
    1
    2
    3
  • Create a rolling average to find the average sale price of the item in the CURRENT row and the PRECEDING nine rows.