MAX

1
SELECT MAX(salary) as highest_salary
2
FROM `project.dataset.employees`
3
WHERE department = 'Engineering';

1
SELECT
2
  region,
3
  MAX(revenue) as highest_revenue,
4
  MAX(order_count) as most_orders
5
FROM `project.dataset.store_performance`
6
GROUP BY region
7
ORDER BY highest_revenue DESC;

1
SELECT
2
  user_id,
3
  MAX(login_timestamp) as last_login
4
FROM `project.dataset.user_sessions`
5
GROUP BY user_id
6
HAVING MAX(login_timestamp) < TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 30 DAY);

1
SELECT
2
  department,
3
  MAX(salary) as max_salary,
4
  ARRAY_AGG(employee_name ORDER BY salary DESC LIMIT 1)[OFFSET(0)] as top_earner
5
FROM `project.dataset.employees`
6
GROUP BY department;