Basic SQL Topics
Aggregations Part 4 — MIN()
See below how to calculate the Minimum population among the 4 California cities from the dataset on the right:
SELECT MIN(2022 estimate)
FROM database_table
WHERE ST = ‘CA’
Now, the SQL statement returns the Min value of 808,437 (from the San Francisco row).