Aggregation

COUNT

Write a query that returns the number of individuals of all species combined (total_abundance) in each year, sorted chronologically. Include the year in the output. Save it as total_abundance_by_year.

[click here for output]