Chapter 2
SQLite3
Section 3
Slices of Data
We've converted a CSV file into Sqlite3 and pulled that data from Sqlite3 into Haskell, now we’re going to demonstrate how use WHERE and ORDER clauses in SQL. - We have lots of earthquake data, but we only want the strongest earthquakes appearing in the Northern Hemisphere. While we could do this with raw Haskell, 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