Chapter 2
SQLite3
Section 4
SQLite3 and Descriptive Statistics
We've learned how to pull data from an SQLite3 database. Now we'd like to take that data and use it in the module that we created from Section 1 - We have lots of earthquake data, but we only want the earthquakes inside of the area of Oklahoma. This is where SQL shines. We're going to issue a SELECT query to grab everything. - Next, we will be discussing the WHERE clause, which will allow us to filter data which only meets our criteria - Finally, we'll be discussing the ORDER BY and the LIMIT clauses in order to sort the data and pull from just the values we want