ANY_VALUE

1
SELECT
2
  order_id,
3
  ANY_VALUE(customer_name) as customer_name,
4
  ANY_VALUE(customer_email) as customer_email,
5
  SUM(quantity) as total_items,
6
  SUM(amount) as total_amount
7
FROM `project.dataset.order_details`
8
GROUP BY order_id;

1
SELECT
2
  product_id,
3
  ANY_VALUE(price HAVING MAX sale_date) as latest_price,
4
  ANY_VALUE(sale_date HAVING MAX sale_date) as price_date
5
FROM `project.dataset.price_history`
6
GROUP BY product_id;

1
SELECT
2
  employee_id,
3
  ANY_VALUE(department HAVING MIN start_date) as first_department,
4
  ANY_VALUE(department HAVING MAX start_date) as current_department
5
FROM `project.dataset.employee_history`
6
GROUP BY employee_id;