ANY_VALUE

1
SELECT department_id,
2
       ANY_VALUE(department_name) AS dept_name,
3
       COUNT(*) AS emp_count
4
FROM employees
5
GROUP BY department_id;

1
SELECT user_id,
2
       ANY_VALUE(username) AS username,
3
       SUM(order_total) AS total_spent
4
FROM orders o
5
JOIN users u ON o.user_id = u.id
6
GROUP BY user_id;

1
SELECT order_id,
2
       ANY_VALUE(customer_name) AS customer,
3
       COUNT(*) AS item_count
4
FROM order_items oi
5
JOIN orders o ON oi.order_id = o.id
6
GROUP BY order_id;