USER http://dig.csail.mit.edu/2009/IARPA-PIR/test/mark.n3
SELECT BIRTHSTATE,MARITALSTATUS,GENDER FROM people WHERE INTERESTS = 'Detroit Pistons |Baltimore Ravens ';
EXECUTE
SELECT BIRTHCITY,ENTRYDATE,BIRTHCOUNTRY FROM people WHERE INTERESTS = 'San Jose Sharks |Atlanta Falcons ';
EXECUTE
SELECT DEPENDENTS,COUNTRY FROM people WHERE BIRTHCITY = 'CAMERON';
EXECUTE
SELECT PUBLICKEYHASH FROM people WHERE INTERESTS = 'New York Yankees |New Orleans Hornets ';
EXECUTE
SELECT PROJECT,SECURITYANSWER,WORKEMAIL FROM people WHERE ZIPCODE = '78566';
EXECUTE
SELECT SECURITYQUESTION,BIRTHSTATE,BIRTHCITY FROM people WHERE INTERESTS = 'Phoenix Coyotes |Utah Jazz ';
EXECUTE
SELECT EDUCATION,STATE FROM people WHERE INTERESTS = 'Sacramento Kings |Portland Trail Blazers ';
EXECUTE
SELECT ENTRYDATE,GENDER,BIRTHCOUNTRY FROM people WHERE ZIPCODE = '59405';
EXECUTE
SELECT STATE,BIRTHCOUNTRY,HOMEPHONE FROM people WHERE INTERESTS = 'Portland Trail Blazers |Boston Bruins ';
EXECUTE
SELECT BIRTHCOUNTRY,WORKPHONE FROM people WHERE FIRSTNAME = 'Lonnie';
EXECUTE
SELECT HOMEEMAIL FROM people WHERE CERTIFICATION = '12/21/2002';
EXECUTE
SELECT PROJECT,DOB FROM people WHERE LASTNAME = 'Cohen';
EXECUTE
SELECT MIDDLENAME,DIRECTDEPOSIT FROM people WHERE LASTNAME = 'Kennedy';
EXECUTE
SELECT BIRTHSTATE,EDUCATION,COUNTRY FROM people WHERE ZIPCODE = '45658';
EXECUTE
SELECT BIRTHCOUNTRY FROM people WHERE CERTIFICATION = '02/20/1999';
EXECUTE
SELECT PASSWORDHASH FROM people WHERE ZIPCODE = '95659';
EXECUTE
SELECT WEIGHT,SECURITYANSWER,DOB FROM people WHERE CERTIFICATION = '03/11/2004';
EXECUTE
SELECT GENDER,CITIZENSHIP FROM people WHERE MIDDLENAME = 'Pearl';
EXECUTE
SELECT BIRTHCOUNTRY,BANKACCOUNT FROM people WHERE FIRSTNAME = 'Byron';
EXECUTE
SELECT INTERESTS,PROJECT FROM people WHERE CERTIFICATION = '11/30/2006';
EXECUTE
SELECT CITIZENSHIP,DEPENDENTS FROM people WHERE INTERESTS = 'Nashville Predators |Arizona Diamondbacks ';
EXECUTE
SELECT HOMEEMAIL FROM people WHERE FIRSTNAME = 'Emily';
EXECUTE
SELECT ENTRYDATE FROM people WHERE MIDDLENAME = 'Allan';
EXECUTE
SELECT DEPENDENTS,IDNUMBER FROM people WHERE LASTNAME = 'Lang';
EXECUTE
SELECT DEPENDENTS,BIRTHCOUNTRY FROM people WHERE CERTIFICATION = '01/08/2005';
EXECUTE
SELECT DEPENDENTS,SECURITYQUESTION FROM people WHERE CERTIFICATION = '07/07/2004';
EXECUTE
SELECT FIRSTNAME,BIRTHSTATE FROM people WHERE BIRTHCITY = 'GEORGETOWN';
EXECUTE
SELECT BIRTHCOUNTRY,ETHNICITY,DIRECTDEPOSIT FROM people WHERE PROJECT = 'Humber';
EXECUTE
SELECT GENDER,PASSWORDHASH,DOB FROM people WHERE CERTIFICATION = '08/03/2005';
EXECUTE
SELECT IDSTATE,BANKACCOUNT,EDUCATION FROM people WHERE CERTIFICATION = '01/24/2000';
EXECUTE
SELECT WEIGHT FROM people WHERE WEIGHT = '198';
EXECUTE
SELECT PASSWORD,RELIGION FROM people WHERE LASTNAME = 'Manning';
EXECUTE
SELECT MARITALSTATUS,BIRTHCITY FROM people WHERE FIRSTNAME = 'Alexandra';
EXECUTE
SELECT EDUCATION FROM people WHERE LASTNAME = 'Chase';
EXECUTE
SELECT SSN,EYECOLOR FROM people WHERE CERTIFICATION = '08/30/2006';
EXECUTE
SELECT SECURITYANSWER FROM people WHERE FIRSTNAME = 'Deanna';
EXECUTE
SELECT SECURITYQUESTION,EYECOLOR,COUNTRY FROM people WHERE INTERESTS = 'Portland Trail Blazers |Green Bay Packers ';
EXECUTE
SELECT DIRECTDEPOSIT,WORKEMAIL,RELIGION FROM people WHERE INTERESTS = 'San Antonio Spurs |Pittsburgh Steelers ';
EXECUTE
SELECT RELIGION,WORKPHONE,MARITALSTATUS FROM people WHERE BIRTHCITY = 'TORRANCE';
EXECUTE
SELECT WEIGHT FROM people WHERE MIDDLENAME = 'Marjorie';
EXECUTE
SELECT WORKEMAIL,INTERESTS FROM people WHERE INTERESTS = 'New York Yankees |Baltimore Orioles ';
EXECUTE
SELECT SSN,BIRTHCITY FROM people WHERE ZIPCODE = '92707';
EXECUTE
SELECT DIRECTDEPOSIT FROM people WHERE CERTIFICATION = '02/27/2009';
EXECUTE
SELECT BANKACCOUNT FROM people WHERE BIRTHCITY = 'NEWARK';
EXECUTE
SELECT BIRTHSTATE,TITLE FROM people WHERE FIRSTNAME = 'Melvin';
EXECUTE
SELECT ENTRYDATE,EYECOLOR FROM people WHERE FIRSTNAME = 'William';
EXECUTE
SELECT WEIGHT,HOMEPHONE,BIRTHCOUNTRY FROM people WHERE LASTNAME = 'Watts';
EXECUTE
SELECT IDNUMBER FROM people WHERE INTERESTS = 'San Francisco 49'ers |New Jersey Devils ';
EXECUTE
SELECT COUNTRY,CITIZENSHIP,MARITALSTATUS FROM people WHERE CERTIFICATION = '05/04/2008';
EXECUTE
SELECT EYECOLOR,EDUCATION FROM people WHERE CERTIFICATION = '04/11/2005';
EXECUTE
SELECT CERTIFICATION,FIRSTNAME FROM people WHERE CERTIFICATION = '07/20/2002';
EXECUTE
SELECT INTERESTS,ETHNICITY,PASSWORD FROM people WHERE ZIPCODE = '95006';
EXECUTE
SELECT HEIGHT,DEPENDENTS FROM people WHERE INTERESTS = 'Dallas Burn |Carolina Hurricanes ';
EXECUTE
SELECT COUNTRY FROM people WHERE LASTNAME = 'Rojas';
EXECUTE
SELECT RELIGION FROM people WHERE CERTIFICATION = '11/18/2004';
EXECUTE
SELECT HAIRCOLOR,USERNAME,EYECOLOR FROM people WHERE ZIPCODE = '89121';
EXECUTE
SELECT ENTRYDATE FROM people WHERE INTERESTS = 'New Jersey Devils |Utah Jazz ';
EXECUTE
SELECT DEPENDENTS,RELIGION,BANKACCOUNT FROM people WHERE CERTIFICATION = '02/16/2000';
EXECUTE
SELECT INTERESTS,PASSWORDHASH,WORKEMAIL FROM people WHERE CERTIFICATION = '08/29/2000';
EXECUTE
SELECT HAIRCOLOR,TITLE,DIRECTDEPOSIT FROM people WHERE CERTIFICATION = '12/08/2005';
EXECUTE
SELECT HEIGHT,RELIGION FROM people WHERE LASTNAME = 'Shaffer';
EXECUTE
SELECT STATE,SSN FROM people WHERE CERTIFICATION = '06/11/2006';
EXECUTE
SELECT WEIGHT,EDUCATION,INTERESTS FROM people WHERE BIRTHCITY = 'MADISON';
EXECUTE
SELECT STATE,COUNTRY,PASSWORDHASH FROM people WHERE CERTIFICATION = '02/19/2000';
EXECUTE
SELECT EDUCATION FROM people WHERE MIDDLENAME = 'Ira';
EXECUTE
SELECT PASSWORDHASH,TITLE,PROJECT FROM people WHERE CERTIFICATION = '01/27/2001';
EXECUTE
SELECT DOB,EYECOLOR,CITIZENSHIP FROM people WHERE BIRTHCITY = 'VERO BEACH';
EXECUTE
SELECT WORKEMAIL,IDNUMBER,BANKACCOUNT FROM people WHERE CERTIFICATION = '01/13/2004';
EXECUTE
SELECT COUNTRY,DOB FROM people WHERE CERTIFICATION = '07/17/1999';
EXECUTE
SELECT MARITALSTATUS FROM people WHERE CERTIFICATION = '06/12/2004';
EXECUTE
SELECT ADDRESS FROM people WHERE RELIGION = 'United Methodist Church';
EXECUTE
SELECT USERNAME,BIRTHSTATE FROM people WHERE FIRSTNAME = 'Jonathon';
EXECUTE
SELECT BIRTHCITY,STATE,MARITALSTATUS FROM people WHERE CERTIFICATION = '01/08/2006';
EXECUTE
SELECT TITLE,COUNTRY,ZIPCODE FROM people WHERE MIDDLENAME = 'Cody';
EXECUTE
SELECT PUBLICKEYHASH FROM people WHERE MIDDLENAME = 'Denise';
EXECUTE
SELECT HEIGHT FROM people WHERE CERTIFICATION = '03/24/1999';
EXECUTE
SELECT CERTIFICATION,MARITALSTATUS FROM people WHERE FIRSTNAME = 'Rufus';
EXECUTE
SELECT HEIGHT,GENDER FROM people WHERE BIRTHCITY = 'SANTA ANA';
EXECUTE
SELECT CERTIFICATION FROM people WHERE CERTIFICATION = '07/16/2008';
EXECUTE
SELECT BIRTHCOUNTRY,WEIGHT FROM people WHERE CERTIFICATION = '11/09/2002';
EXECUTE
SELECT MARITALSTATUS FROM people WHERE MIDDLENAME = 'Steve';
EXECUTE
SELECT MARITALSTATUS,IDSTATE,HEIGHT FROM people WHERE FIRSTNAME = 'Edna';
EXECUTE
SELECT TITLE,PUBLICKEYHASH FROM people WHERE INTERESTS = 'San Jose Sharks |Minnesota Twins ';
EXECUTE
SELECT DOB,SUFFIX FROM people WHERE BIRTHCITY = 'MODESTO';
EXECUTE
SELECT RELIGION FROM people WHERE ZIPCODE = '48879';
EXECUTE
SELECT PUBLICKEYHASH FROM people WHERE ZIPCODE = '14411';
EXECUTE
SELECT DOB,SECURITYANSWER,BIRTHCOUNTRY FROM people WHERE CERTIFICATION = '10/18/2005';
EXECUTE
SELECT TITLE FROM people WHERE INTERESTS = 'San Francisco 49'ers |Atlanta Thrashers ';
EXECUTE
SELECT ENTRYDATE,WEIGHT,CERTIFICATION FROM people WHERE CERTIFICATION = '08/28/2006';
EXECUTE
SELECT TITLE,HEIGHT FROM people WHERE INTERESTS = 'San Jose Sharks |Portland Trail Blazers ';
EXECUTE
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
