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.