Dplyr databases source and query (solution)

Exercise

Output solution

Attaching package: 'dplyr'

The following objects are masked from 'package:stats':

    filter, lag

The following objects are masked from 'package:base':

    intersect, setdiff, setequal, union

[1] "plots"                         "species"                      
[3] "sqlite_stat1"                  "sqlite_stat4"                 
[5] "surveys"                       "target_species_weight_by_year"

[1] "record_id"       "month"           "day"             "year"           
[5] "plot_id"         "species_id"      "sex"             "hindfoot_length"
[9] "weight"         

[1] "plot_id"   "plot_type"

# Source:   SQL [1 x 2]
# Database: sqlite 3.46.0 [/home/runner/work/dcsem-solutions/dcsem-solutions/data/portal_mammals.sqlite]
  `AVG(s.hindfoot_length)` `AVG(s.weight)`
                     <dbl>           <dbl>
1                     50.0            120.

# Source:   SQL [1 x 2]
# Database: sqlite 3.46.0 [/home/runner/work/dcsem-solutions/dcsem-solutions/data/portal_mammals.sqlite]
  `AVG(s.hindfoot_length)` `AVG(s.weight)`
                     <dbl>           <dbl>
1                     50.5            123.

# Source:   SQL [1 x 2]
# Database: sqlite 3.46.0 [/home/runner/work/dcsem-solutions/dcsem-solutions/data/portal_mammals.sqlite]
  `AVG(s.hindfoot_length)` `AVG(s.weight)`
                     <dbl>           <dbl>
1                     49.5            117.