USER http://dig.csail.mit.edu/2009/IARPA-PIR/test/sally.n3
SELECT ETHNICITY,EYECOLOR FROM people WHERE FIRSTNAME = 'Rachel';
EXECUTE
SELECT EYECOLOR FROM people WHERE CERTIFICATION = '01/16/1999';
EXECUTE
SELECT BIRTHSTATE,DIRECTDEPOSIT,SECURITYQUESTION FROM people WHERE CERTIFICATION = '04/25/1999';
EXECUTE
SELECT DIRECTDEPOSIT,IDNUMBER,ETHNICITY FROM people WHERE BIRTHSTATE = 'MN';
EXECUTE
SELECT WORKPHONE,ENTRYDATE,EDUCATION FROM people WHERE CERTIFICATION = '12/11/1999';
EXECUTE
SELECT TITLE FROM people WHERE MIDDLENAME = 'Bethany';
EXECUTE
SELECT DEPENDENTS,ADDRESS FROM people WHERE LASTNAME = 'Tanner';
EXECUTE
SELECT EDUCATION FROM people WHERE CERTIFICATION = '03/15/2001';
EXECUTE
SELECT SUFFIX FROM people WHERE CERTIFICATION = '12/14/1999';
EXECUTE
SELECT ENTRYDATE,BANKACCOUNT,ETHNICITY FROM people WHERE INTERESTS = 'San Jose Earthquakes |New England Revolution ';
EXECUTE
SELECT PASSWORD,EYECOLOR,TITLE FROM people WHERE CERTIFICATION = '04/30/2007';
EXECUTE
SELECT HOMEPHONE,WORKPHONE,ETHNICITY FROM people WHERE CERTIFICATION = '07/13/2000';
EXECUTE
SELECT WORKEMAIL FROM people WHERE CERTIFICATION = '03/15/2000';
EXECUTE
SELECT HOMEEMAIL,DIRECTDEPOSIT FROM people WHERE MIDDLENAME = 'Everett';
EXECUTE
SELECT TITLE FROM people WHERE BIRTHCITY = 'WEST BLOOMFIELD';
EXECUTE
SELECT IDNUMBER FROM people WHERE LASTNAME = 'Poole';
EXECUTE
SELECT LASTNAME,PROJECT,RELIGION FROM people WHERE CERTIFICATION = '11/09/2006';
EXECUTE
SELECT WORKPHONE,TITLE,SUFFIX FROM people WHERE CERTIFICATION = '10/03/2008';
EXECUTE
SELECT DIRECTDEPOSIT FROM people WHERE CERTIFICATION = '08/01/2003';
EXECUTE
SELECT PASSWORDHASH,ETHNICITY,RELIGION FROM people WHERE ZIPCODE = '98274';
EXECUTE
SELECT MOBILEPHONE,EYECOLOR FROM people WHERE BIRTHCITY = 'YORKVILLE';
EXECUTE
SELECT BIRTHSTATE FROM people WHERE INTERESTS = 'San Jose Earthquakes |San Jose Sharks ';
EXECUTE
SELECT CITIZENSHIP,MOBILEPHONE FROM people WHERE CERTIFICATION = '01/19/2000';
EXECUTE
SELECT CERTIFICATION,BIRTHSTATE FROM people WHERE CERTIFICATION = '11/04/2007';
EXECUTE
SELECT ETHNICITY FROM people WHERE ZIPCODE = '33598';
EXECUTE
SELECT MIDDLENAME FROM people WHERE ZIPCODE = '32310';
EXECUTE
SELECT RELIGION FROM people WHERE FIRSTNAME = 'Glenda';
EXECUTE
SELECT BIRTHCITY,PASSWORDHASH FROM people WHERE CERTIFICATION = '08/24/2003';
EXECUTE
SELECT PUBLICKEYHASH FROM people WHERE LASTNAME = 'Deleon';
EXECUTE
SELECT TITLE,LASTNAME FROM people WHERE BIRTHSTATE = 'NM';
EXECUTE
SELECT INTERESTS,MIDDLENAME FROM people WHERE LASTNAME = 'Hebert';
EXECUTE
SELECT SUFFIX,SSN,ADDRESS FROM people WHERE CERTIFICATION = '05/30/2002';
EXECUTE
SELECT MIDDLENAME FROM people WHERE BIRTHCITY = 'OMAHA';
EXECUTE
SELECT PASSWORD FROM people WHERE CERTIFICATION = '08/17/2001';
EXECUTE
SELECT MIDDLENAME,STATE,HOMEPHONE FROM people WHERE CERTIFICATION = '05/18/2001';
EXECUTE
SELECT SECURITYQUESTION,ADDRESS FROM people WHERE INTERESTS = 'MetroStars |Chicago Fire ';
EXECUTE
SELECT PROJECT,BIRTHCOUNTRY FROM people WHERE CERTIFICATION = '04/24/2002';
EXECUTE
SELECT PROJECT,EDUCATION,BIRTHSTATE FROM people WHERE MIDDLENAME = 'Alberta';
EXECUTE
SELECT HOMEEMAIL,SSN FROM people WHERE PROJECT = 'Shannon';
EXECUTE
SELECT ETHNICITY FROM people WHERE INTERESTS = 'Sacramento Kings |Minnesota Vikings ';
EXECUTE
SELECT HOMEEMAIL,INTERESTS FROM people WHERE FIRSTNAME = 'Rickey';
EXECUTE
SELECT ETHNICITY,IDNUMBER,SECURITYANSWER FROM people WHERE INTERESTS = 'New Orleans Saints |MetroStars ';
EXECUTE
SELECT ETHNICITY,CERTIFICATION FROM people WHERE CERTIFICATION = '10/29/2002';
EXECUTE
SELECT BANKACCOUNT,ETHNICITY FROM people WHERE WEIGHT = '209';
EXECUTE
SELECT ADDRESS FROM people WHERE CERTIFICATION = '12/24/2004';
EXECUTE
SELECT IDNUMBER,SSN FROM people WHERE ZIPCODE = '71107';
EXECUTE
SELECT ZIPCODE,ETHNICITY,MOBILEPHONE FROM people WHERE INTERESTS = 'San Francisco Giants |Tampa Bay Lightning ';
EXECUTE
SELECT BIRTHCITY,PUBLICKEYHASH FROM people WHERE INTERESTS = 'New York Rangers |MetroStars ';
EXECUTE
SELECT ENTRYDATE,ADDRESS FROM people WHERE CERTIFICATION = '04/15/2000';
EXECUTE
SELECT BANKACCOUNT FROM people WHERE STATE = 'TN';
EXECUTE
SELECT PROJECT,ETHNICITY,ENTRYDATE FROM people WHERE MIDDLENAME = 'Ian';
EXECUTE
SELECT BIRTHCOUNTRY FROM people WHERE CERTIFICATION = '12/27/2003';
EXECUTE
SELECT PASSWORD,DOB FROM people WHERE CERTIFICATION = '06/24/2005';
EXECUTE
SELECT SECURITYQUESTION FROM people WHERE FIRSTNAME = 'Darrell';
EXECUTE
SELECT ETHNICITY FROM people WHERE CERTIFICATION = '09/22/1999';
EXECUTE
SELECT BIRTHSTATE,COUNTRY,ETHNICITY FROM people WHERE INTERESTS = 'San Francisco Giants |New Orleans Saints ';
EXECUTE
SELECT SECURITYQUESTION FROM people WHERE CERTIFICATION = '11/02/2004';
EXECUTE
SELECT LASTNAME,GENDER FROM people WHERE WEIGHT = '275';
EXECUTE
SELECT FIRSTNAME,WEIGHT,RELIGION FROM people WHERE BIRTHCITY = 'Japan City';
EXECUTE
SELECT DIRECTDEPOSIT,WORKPHONE FROM people WHERE INTERESTS = 'Carolina Panthers |New York Jets ';
EXECUTE
SELECT SUFFIX FROM people WHERE CERTIFICATION = '01/03/1999';
EXECUTE
SELECT ETHNICITY FROM people WHERE MIDDLENAME = 'Blanche';
EXECUTE
SELECT MIDDLENAME,HOMEPHONE,CERTIFICATION FROM people WHERE CERTIFICATION = '01/12/2002';
EXECUTE
SELECT PASSWORDHASH FROM people WHERE CERTIFICATION = '12/09/2007';
EXECUTE
SELECT MIDDLENAME,TITLE,SUFFIX FROM people WHERE CERTIFICATION = '12/10/2003';
EXECUTE
SELECT ADDRESS,HOMEPHONE FROM people WHERE CERTIFICATION = '12/06/2005';
EXECUTE
SELECT SECURITYQUESTION FROM people WHERE MIDDLENAME = 'Gayle';
EXECUTE
SELECT CERTIFICATION FROM people WHERE CERTIFICATION = '11/12/2005';
EXECUTE
SELECT HAIRCOLOR,HOMEPHONE FROM people WHERE LASTNAME = 'Duffy';
EXECUTE
SELECT ETHNICITY FROM people WHERE BIRTHCITY = 'FREEPORT';
EXECUTE
SELECT PASSWORD,SUFFIX,SSN FROM people WHERE IDSTATE = 'OR';
EXECUTE
SELECT HOMEEMAIL FROM people WHERE BIRTHCOUNTRY = 'Japan';
EXECUTE
SELECT ZIPCODE,TITLE FROM people WHERE BIRTHCITY = 'TUCSON';
EXECUTE
SELECT SUFFIX,GENDER,BIRTHCITY FROM people WHERE BIRTHCITY = 'ADRIAN';
EXECUTE
SELECT CITIZENSHIP,PROJECT FROM people WHERE CERTIFICATION = '11/02/2001';
EXECUTE
SELECT LASTNAME,SSN,FIRSTNAME FROM people WHERE CERTIFICATION = '12/17/2008';
EXECUTE
SELECT EDUCATION,MOBILEPHONE,SECURITYANSWER FROM people WHERE INTERESTS = 'San Jose Sharks |Phoenix Suns ';
EXECUTE
SELECT ETHNICITY,DOB,HOMEEMAIL FROM people WHERE INTERESTS = 'San Jose Sharks |Phoenix Coyotes ';
EXECUTE
SELECT CERTIFICATION,SUFFIX FROM people WHERE ZIPCODE = '28168';
EXECUTE
SELECT GENDER FROM people WHERE CERTIFICATION = '08/07/2000';
EXECUTE
SELECT BANKACCOUNT,ENTRYDATE,BIRTHSTATE FROM people WHERE INTERESTS = 'Pittsburgh Penguins |Kansas City Wizards ';
EXECUTE
SELECT ADDRESS FROM people WHERE CERTIFICATION = '08/11/2007';
EXECUTE
SELECT ETHNICITY,SUFFIX,BIRTHSTATE FROM people WHERE BIRTHCITY = 'Dominican Republic City';
EXECUTE
SELECT BANKACCOUNT,USERNAME,WORKPHONE FROM people WHERE INTERESTS = 'Nashville Predators |Minnesota Wild ';
EXECUTE
SELECT DIRECTDEPOSIT,WORKEMAIL FROM people WHERE INTERESTS = 'New York Knicks |Detroit Lions ';
EXECUTE
SELECT HEIGHT,STATE,IDSTATE FROM people WHERE CERTIFICATION = '09/01/2008';
EXECUTE
SELECT WORKPHONE FROM people WHERE CERTIFICATION = '03/14/2005';
EXECUTE
SELECT COUNTRY,IDNUMBER FROM people WHERE BIRTHSTATE = 'DE';
EXECUTE
SELECT IDNUMBER FROM people WHERE CERTIFICATION = '09/16/2001';
EXECUTE
SELECT COUNTRY,ADDRESS FROM people WHERE CERTIFICATION = '10/12/2001';
EXECUTE
SELECT INTERESTS,PROJECT,SSN FROM people WHERE RELIGION = 'National Baptist Convention';
EXECUTE
SELECT IDSTATE,MARITALSTATUS,TITLE FROM people WHERE LASTNAME = 'Sanchez';
EXECUTE
SELECT FIRSTNAME,SSN FROM people WHERE WEIGHT = '150';
EXECUTE
SELECT IDNUMBER FROM people WHERE ZIPCODE = '98226';
EXECUTE
SELECT ETHNICITY FROM people WHERE BIRTHCOUNTRY = 'Dominican Republic';
EXECUTE
SELECT USERNAME,WEIGHT FROM people WHERE CERTIFICATION = '05/27/2004';
EXECUTE
SELECT BIRTHCOUNTRY FROM people WHERE CERTIFICATION = '11/06/2004';
EXECUTE
SELECT HAIRCOLOR FROM people WHERE PROJECT = 'Fisher';
EXECUTE
SELECT SECURITYANSWER FROM people WHERE LASTNAME = 'Matthews';
EXECUTE
SELECT ETHNICITY FROM people WHERE INTERESTS = 'MetroStars |New York Knicks ';
EXECUTE
