LAST

1
SELECT
2
  customer_id,
3
  LAST(order_id ORDER BY order_date) as last_order_id,
4
  LAST(order_date ORDER BY order_date) as last_order_date
5
FROM orders
6
GROUP BY customer_id;

1
SELECT
2
  product_id,
3
  FIRST(price ORDER BY date) as initial_price,
4
  LAST(price ORDER BY date) as current_price,
5
  LAST(price ORDER BY date) - FIRST(price ORDER BY date) as price_change
6
FROM price_history
7
GROUP BY product_id;