In this post we’re going to write SQL syntax and intertwine that with R code to enable you to use both, if you are familiar with both.

We will also look at the tidyquery package which allows you to learn dplyr if you’re more familiar with SQL, but keen to grasp more dplyr.