Utilizing SQL, how to solve this?

The objective of this section is to contruct SQL queries to extract relavant information from the data tables. The best resource for referencing the syntax of SQL queries is https://dev.mysql.com/doc/. Note that this documentation is for the MySQL database. However, SQLite and MySQL and other SQL derived databases all have a common syntax. (There may, however, be some slight variation between the versions.) First we will build a query to pull all the data rows from table 'zip' where 'Latitude' is greater than 55 using dbGetQuery. sql_qry = "SELECT * FROM zip WHERE Latitude >55" head (dbGetQuery(dbcon, sql_qry)) The syntax is SELECT *, where the * means 'select everything, but this could be replaced with specific column names. The argument FROM tells SQL which table to use. The argument WHERE says which specific pieces of data you want SQL to return. After creating the query string, we use dbGetQuery to pull the records from the table. You can also make composite requests just like you can in R, using the strings AND or OR. The syntax for the logical statements is more readable in SQL than they are in R: sql_qry = "SELECT * FROM zip WHERE Latitude>55 AND Longitude