MAX

1
SELECT MAX(salary) as highest_salary
2
FROM employees;

1
SELECT
2
  MAX(score) as overall_max,
3
  MAX(score) FILTER (WHERE subject = 'Math') as max_math,
4
  MAX(score) FILTER (WHERE subject = 'Science') as max_science
5
FROM exam_results;

1
SELECT
2
  DATE_TRUNC('month', order_date) as month,
3
  MIN(total_amount) as min_order,
4
  MAX(total_amount) as max_order,
5
  MAX(total_amount) - MIN(total_amount) as order_range
6
FROM orders
7
GROUP BY DATE_TRUNC('month', order_date)
8
ORDER BY month;