Execute SQL query on CalCOFI database

Source: R/read.R

Convenience function to execute arbitrary SQL queries against a frozen CalCOFI database release.

cc_query(sql, version = "latest")

Arguments

sql

SQL query string

version

Database version (default: "latest")

Value

Tibble with query results

Examples

if (FALSE) { # \dontrun{
results <- cc_query("SELECT * FROM larva LIMIT 10")
results <- cc_query("SELECT species_id, COUNT(*) as n FROM larva GROUP BY species_id")
} # }