USER http://dig.csail.mit.edu/2009/IARPA-PIR/test/mark.n3
SELECT IDSTATE,BIRTHCITY FROM people WHERE CERTIFICATION = '12/10/2008';
EXECUTE
SELECT IDSTATE,BIRTHCOUNTRY FROM people WHERE CERTIFICATION = '01/02/2001';
EXECUTE
SELECT HAIRCOLOR,USERNAME,ETHNICITY FROM people WHERE CERTIFICATION = '07/14/2004';
EXECUTE
SELECT DIRECTDEPOSIT,GENDER FROM people WHERE CERTIFICATION = '02/06/2008';
EXECUTE
SELECT WEIGHT,DEPENDENTS FROM people WHERE INTERESTS = 'Pittsburgh Pirates |New Orleans Saints ';
EXECUTE
SELECT HEIGHT,TITLE,HOMEEMAIL FROM people WHERE BIRTHCOUNTRY = 'Ecuador';
EXECUTE
SELECT DIRECTDEPOSIT,EDUCATION FROM people WHERE INTERESTS = 'Arizona Diamondbacks |New Orleans Hornets ';
EXECUTE
SELECT IDSTATE,WORKPHONE FROM people WHERE ETHNICITY = 'Black or African American';
EXECUTE
SELECT DOB,ADDRESS FROM people WHERE CERTIFICATION = '08/27/1999';
EXECUTE
SELECT WORKPHONE,CITIZENSHIP FROM people WHERE FIRSTNAME = 'Maureen';
EXECUTE
