New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Vignette: create SQL tutorial using data #21

Open

erictleung opened this issue Nov 30, 2021 · 0 comments

Owner

erictleung commented Nov 30, 2021

Topics/commands to cover:

SELECT
FROM
WHERE
GROUP BY/HAVING
ORDER BY
LEFT/RIGHT JOIN
CASE WHEN
DISTINCT
Date manipulation?
LAG and LEAD
Running totals https://learnsql.com/blog/what-is-a-running-total-and-how-to-compute-it-in-sql/
INNER JOIN
COUNT/MIN/MAX/AVG
CTEs

Can make similarities with dplyr/tidyverse verbs.

Questions to answer:

Which were Pixar's top movies? By rating? By box office?
Which producer creates the best movies?
What is the average cadence of movies released?
With movies with sequels, what is their cumulative box office sales?
What is Pixar's cumulative sales over time?
What is the distribution of movie genres across Pixar?

Implementation:

dbplyr, to execute SQL code natively
learnr? Needs to Shiny so maybe not immediately

erictleung changed the title ~~Create SQL tutorial using data~~ Vignette: create SQL tutorial using data

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment