Week 6.1 - Who were the winners?

Please use Canvas to return the assignments: https://ucsb.instructure.com/courses/32934/assignments/474658

At the conclusion of the ASDN project the PIs decided to hand out first, second, and third prizes to the observers who measured the most eggs. Who won? Please use R and dbplyr to answer this question, and please upload to Canvas your R code as a Quarto document (.qmd), including the answers to the questions below.

Your code should print out:

# Ordered by: desc(total_eggs)
  Name            total_eggs
  <chr>                <int>
1 Vanessa Loverti        163
2 Dylan Kessler           87
3 Richard Lanctot         50

You’ll want to load database tables using statements such as:

egg_table <- tbl(conn, "Bird_eggs")

and then use tidyverse grouping, summarization, joining, and other functions to compute the desired result.

Also, take your final expression and pipe it into show_query().

If you used multiple R statements, did:

-dbplyr create a temporary table? Or did it manage to do everything in one query?

• Did it limit to the first three rows using an R expression or an SQL LIMIT clause?

Credit: 40 points