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. ... (PctChange_2020) AS Lowest_PctChange_2020 FROM states GROUP BY Division;") ...