In R, the sqldf package lets you run SQL queries on an R data frame, and that’s what I’ll use in this example. There’s a similar sqldf library in Python.

Learn the basics of Python, SQL and languages on your phone. Here are the top apps for aspiring coders and engineers.