Advanced Queries

JOIN 1


The Plots table in the Portal database can be joined to the Surveys table by joining plot_id to plot_id and the Species table can be joined to the Surveys table by joining species_id to species_id.

The Portal mammal data include data from a number of different experimental manipulations. You want to do a time-series analysis of the natural population dynamics of all of the rodent species at the site, so write a query that returns the year, month, day, genus and species of every individual captured on the Control plots. Choose only rodent species (i.e., species for which the taxa field in the species table is Rodent) and exclude all individuals that have not been identified to genus (i.e., species for which the species_id field in the species table is UR). For easier viewing, sort the results alphabetically by genus and species and then chronologically. Save this query as data_from_controls.

[click here for output]