FIRST_VALUE

1
SELECT
2
  product_id,
3
  date,
4
  price,
5
  FIRST_VALUE(price) OVER (
6
    PARTITION BY product_id
7
    ORDER BY date
8
    ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
9
  ) as initial_price
10
FROM price_history;

1
SELECT
2
  date,
3
  revenue,
4
  FIRST_VALUE(revenue) OVER (ORDER BY date) as first_revenue,
5
  revenue - FIRST_VALUE(revenue) OVER (ORDER BY date) as growth_from_start
6
FROM monthly_revenue;

1
SELECT
2
  department,
3
  name,
4
  hire_date,
5
  FIRST_VALUE(name) OVER (
6
    PARTITION BY department
7
    ORDER BY hire_date
8
  ) as first_hire
9
FROM employees;