ARG_MIN

1
SELECT
2
  category,
3
  ARG_MIN(name, price) as cheapest_product,
4
  MIN(price) as lowest_price
5
FROM products
6
GROUP BY category;

1
SELECT
2
  department,
3
  ARG_MIN(name, hire_date) as senior_employee,
4
  MIN(hire_date) as earliest_hire
5
FROM employees
6
GROUP BY department;

1
SELECT
2
  customer_id,
3
  ARG_MIN(product_name, order_date) as first_product,
4
  ARG_MIN(order_id, order_date) as first_order_id
5
FROM orders
6
GROUP BY customer_id;