Advanced Queries

JOIN 4


Write a query that displays the total number of rodent individuals sampled on each plot_type. Save this query as individuals_per_plot_type.

Note that the number of plots varies among plot types so this number isn’t very informative. We’ll learn how to take this into account soon.

[click here for output]