Link and Query (dplyr Databases)
- Connect to
portal_mammals.sqlite as object portaldb using dplyr.
- Start by reminding yourself about which tables are in the database using
src_tbls()
- Then remind yourself of the fields in the
surveys and plots tables using
the list subset operator $ops$vars.
- Select and print out the average hind foot length and average weight of:
- all Dipodomys spectabilis individuals on the control plots
- male D. spectabilis on the control plots
- female D. spectabilis on the control plots
Expected outputs for Link and Query: