Assignments for Feb. 19

Complete this SQLite Tutorial and send me the mycds.sl3 database file (it will be created in the directory where you start this tutorial).

Using the Fairfax arrest db, write SQL queries to accomplish the following. You can send the queries directly to me in an email or as a text file attachment.

  1. Show all of the records where the age of the person is 47
  2. Show all of the records where the state is Maryland
  3. Show all of the records where the city is Herndon and the age of the person is less than 30

Story: USA Today

Advertisements

About this entry