Basic SQL Topics
Aggregations Part 5 — MAX()
See below how to calculate the Maximum population among the 4 California cities from the dataset on the right:
SELECT MAX(2022 estimate)
FROM database_table
WHERE ST = ‘CA’
Now, the SQL statement returns the Max value of 3.8 million (from the Los Angeles row).