USER http://dig.csail.mit.edu/2009/IARPA-PIR/test/chuck.n3
SELECT LASTNAME FROM people WHERE FIRSTNAME = 'Alice';
EXECUTE
SELECT PROJECT,ZIPCODE,FIRSTNAME FROM people WHERE STATE = 'CT';
EXECUTE
SELECT ETHNICITY,PUBLICKEYHASH,SSN FROM people WHERE STATE = 'MA';
EXECUTE
SELECT DEPENDENTS,BANKACCOUNT FROM people WHERE MIDDLENAME = 'Norma';
EXECUTE
SELECT TITLE,SUFFIX,SSN FROM people WHERE MIDDLENAME = 'Jose';
EXECUTE
SELECT SECURITYANSWER FROM people WHERE WEIGHT = '134';
EXECUTE
SELECT HAIRCOLOR,LASTNAME FROM people WHERE STATE = 'NJ';
EXECUTE
SELECT WORKEMAIL,IDSTATE,SSN FROM people WHERE PROJECT = 'Thames';
EXECUTE
SELECT RELIGION,COUNTRY FROM people WHERE STATE = 'VT';
EXECUTE
SELECT PROJECT,HEIGHT,FIRSTNAME FROM people WHERE LASTNAME = 'Bailey';
EXECUTE
SELECT EDUCATION,DEPENDENTS,MIDDLENAME FROM people WHERE MIDDLENAME = 'Daniel';
EXECUTE
SELECT RELIGION,SUFFIX,CERTIFICATION FROM people WHERE BIRTHSTATE = 'AK';
EXECUTE
SELECT FIRSTNAME FROM people WHERE STATE = 'MA';
EXECUTE
SELECT ETHNICITY,LASTNAME,CITIZENSHIP FROM people WHERE MIDDLENAME = 'David';
EXECUTE
SELECT WORKPHONE,BIRTHCITY,DIRECTDEPOSIT FROM people WHERE FIRSTNAME = 'Richard';
EXECUTE
SELECT MIDDLENAME FROM people WHERE STATE = 'NJ';
EXECUTE
SELECT COUNTRY,PUBLICKEYHASH FROM people WHERE FIRSTNAME = 'Wendy';
EXECUTE
SELECT CERTIFICATION,WORKPHONE FROM people WHERE MIDDLENAME = 'Nicholas';
EXECUTE
SELECT BIRTHSTATE FROM people WHERE STATE = 'NY';
EXECUTE
SELECT IDSTATE FROM people WHERE FIRSTNAME = 'Cindy';
EXECUTE
SELECT BANKACCOUNT,HEIGHT,ETHNICITY FROM people WHERE WEIGHT = '192';
EXECUTE
SELECT WEIGHT,CITIZENSHIP,DOB FROM people WHERE MIDDLENAME = 'Heather';
EXECUTE
SELECT INTERESTS,IDSTATE,LASTNAME FROM people WHERE WEIGHT = '163';
EXECUTE
SELECT IDNUMBER,FIRSTNAME FROM people WHERE HEIGHT = '73';
EXECUTE
SELECT DEPENDENTS,MARITALSTATUS FROM people WHERE BIRTHSTATE = 'KY';
EXECUTE
SELECT BIRTHYEAR,ETHNICITY,BIRTHCITY FROM people WHERE BIRTHCITY = 'KANSAS CITY';
EXECUTE
SELECT PASSWORD,DOB,LASTNAME FROM people WHERE RELIGION = 'Assemblies of God';
EXECUTE
SELECT ENTRYDATE,SECURITYANSWER,BIRTHCITY FROM people WHERE MIDDLENAME = 'Patrick';
EXECUTE
SELECT BANKACCOUNT,MIDDLENAME FROM people WHERE STATE = 'ME';
EXECUTE
SELECT SUFFIX FROM people WHERE STATE = 'PA';
EXECUTE
SELECT LASTNAME,GENDER FROM people WHERE STATE = 'RI';
EXECUTE
SELECT SECURITYANSWER FROM people WHERE MIDDLENAME = 'Julie';
EXECUTE
SELECT EDUCATION,BANKACCOUNT,DIRECTDEPOSIT FROM people WHERE BIRTHCITY = 'El Salvador City';
EXECUTE
SELECT IDNUMBER,PROJECT,INTERESTS FROM people WHERE FIRSTNAME = 'Richard';
EXECUTE
SELECT FIRSTNAME FROM people WHERE FIRSTNAME = 'Mike';
EXECUTE
SELECT SUFFIX,WORKEMAIL,SECURITYQUESTION FROM people WHERE STATE = 'PA';
EXECUTE
SELECT HAIRCOLOR,ADDRESS,HOMEEMAIL FROM people WHERE IDSTATE = 'KS';
EXECUTE
SELECT SECURITYQUESTION FROM people WHERE INTERESTS = 'San Francisco Giants |Portland Trail Blazers ';
EXECUTE
SELECT DIRECTDEPOSIT,USERNAME,IDSTATE FROM people WHERE WEIGHT = '147';
EXECUTE
SELECT LASTNAME,WORKEMAIL FROM people WHERE STATE = 'CT';
EXECUTE
SELECT IDSTATE,DEPENDENTS,HOMEEMAIL FROM people WHERE FIRSTNAME = 'Bruce';
EXECUTE
SELECT SSN FROM people WHERE MIDDLENAME = 'Denise';
EXECUTE
SELECT LASTNAME FROM people WHERE BIRTHCITY = 'TAMPA';
EXECUTE
SELECT SSN,WORKPHONE FROM people WHERE IDSTATE = 'ID';
EXECUTE
SELECT SECURITYANSWER,SUFFIX FROM people WHERE WEIGHT = '158';
EXECUTE
SELECT CITIZENSHIP,RELIGION,ETHNICITY FROM people WHERE RELIGION = 'Southern Baptist Convention';
EXECUTE
SELECT ADDRESS,HEIGHT,CITIZENSHIP FROM people WHERE FIRSTNAME = 'Susan';
EXECUTE
SELECT FIRSTNAME FROM people WHERE FIRSTNAME = 'Ernest';
EXECUTE
SELECT SUFFIX FROM people WHERE STATE = 'NY';
EXECUTE
SELECT SUFFIX,BIRTHSTATE FROM people WHERE MIDDLENAME = 'Andrea';
EXECUTE
SELECT ADDRESS FROM people WHERE STATE = 'ME';
EXECUTE
SELECT MOBILEPHONE,CITIZENSHIP,HOMEPHONE FROM people WHERE STATE = 'NJ';
EXECUTE
SELECT COUNTRY,MIDDLENAME,STATE FROM people WHERE STATE = 'RI';
EXECUTE
SELECT EYECOLOR,DIRECTDEPOSIT,WEIGHT FROM people WHERE WEIGHT = '164';
EXECUTE
SELECT SUFFIX,BANKACCOUNT FROM people WHERE STATE = 'CT';
EXECUTE
SELECT MIDDLENAME,TITLE FROM people WHERE WEIGHT = '265';
EXECUTE
SELECT LASTNAME FROM people WHERE STATE = 'CT';
EXECUTE
SELECT PROJECT,INTERESTS FROM people WHERE LASTNAME = 'Lopez';
EXECUTE
SELECT FIRSTNAME,BIRTHYEAR,CERTIFICATION FROM people WHERE STATE = 'NY';
EXECUTE
SELECT HEIGHT,ADDRESS FROM people WHERE FIRSTNAME = 'Karen';
EXECUTE
SELECT DIRECTDEPOSIT FROM people WHERE STATE = 'NH';
EXECUTE
SELECT CITIZENSHIP,LASTNAME FROM people WHERE STATE = 'RI';
EXECUTE
SELECT MIDDLENAME,IDNUMBER FROM people WHERE STATE = 'NE';
EXECUTE
SELECT HAIRCOLOR,EDUCATION FROM people WHERE FIRSTNAME = 'Bruce';
EXECUTE
SELECT TITLE,WEIGHT FROM people WHERE STATE = 'RI';
EXECUTE
SELECT PASSWORDHASH FROM people WHERE IDSTATE = 'WI';
EXECUTE
SELECT USERNAME,MIDDLENAME FROM people WHERE STATE = 'NJ';
EXECUTE
SELECT STATE,WORKEMAIL,INTERESTS FROM people WHERE FIRSTNAME = 'Lawrence';
EXECUTE
SELECT DIRECTDEPOSIT FROM people WHERE STATE = 'ME';
EXECUTE
SELECT BIRTHSTATE,EYECOLOR,SUFFIX FROM people WHERE STATE = 'RI';
EXECUTE
SELECT STATE,HOMEPHONE,WORKEMAIL FROM people WHERE MIDDLENAME = 'Crystal';
EXECUTE
SELECT BANKACCOUNT,USERNAME FROM people WHERE STATE = 'LA';
EXECUTE
SELECT PASSWORD FROM people WHERE STATE = 'NH';
EXECUTE
SELECT HOMEPHONE,IDSTATE FROM people WHERE STATE = 'VT';
EXECUTE
SELECT SECURITYQUESTION,DIRECTDEPOSIT FROM people WHERE FIRSTNAME = 'Gerald';
EXECUTE
SELECT HEIGHT,DOB FROM people WHERE BIRTHCITY = 'COLUMBUS';
EXECUTE
SELECT FIRSTNAME FROM people WHERE LASTNAME = 'Lee';
EXECUTE
SELECT MIDDLENAME,COUNTRY,PASSWORD FROM people WHERE BIRTHCOUNTRY = 'El Salvador';
EXECUTE
SELECT HAIRCOLOR FROM people WHERE PROJECT = 'Tyne';
EXECUTE
SELECT DIRECTDEPOSIT,SSN FROM people WHERE HEIGHT = '73';
EXECUTE
SELECT BIRTHCITY,DIRECTDEPOSIT,PUBLICKEYHASH FROM people WHERE STATE = 'NH';
EXECUTE
SELECT IDNUMBER,TITLE,WORKPHONE FROM people WHERE STATE = 'ME';
EXECUTE
SELECT PUBLICKEYHASH FROM people WHERE STATE = 'CT';
EXECUTE
SELECT STATE,BIRTHSTATE FROM people WHERE STATE = 'NY';
EXECUTE
SELECT SUFFIX,WEIGHT,DOB FROM people WHERE STATE = 'ME';
EXECUTE
SELECT IDSTATE,SECURITYANSWER FROM people WHERE EYECOLOR = 'GRY';
EXECUTE
SELECT ETHNICITY,PASSWORDHASH,HOMEPHONE FROM people WHERE STATE = 'CT';
EXECUTE
SELECT ETHNICITY,ADDRESS FROM people WHERE STATE = 'IL';
EXECUTE
SELECT MIDDLENAME,COUNTRY,PASSWORDHASH FROM people WHERE LASTNAME = 'Davis';
EXECUTE
SELECT LASTNAME FROM people WHERE STATE = 'VT';
EXECUTE
SELECT MOBILEPHONE FROM people WHERE IDSTATE = 'IL';
EXECUTE
SELECT COUNTRY,WEIGHT,INTERESTS FROM people WHERE STATE = 'MA';
EXECUTE
SELECT HEIGHT,PASSWORDHASH FROM people WHERE FIRSTNAME = 'Keith';
EXECUTE
SELECT WEIGHT,HEIGHT FROM people WHERE STATE = 'MA';
EXECUTE
SELECT SECURITYQUESTION,RELIGION,ZIPCODE FROM people WHERE STATE = 'NY';
EXECUTE
SELECT HEIGHT,DIRECTDEPOSIT,MIDDLENAME FROM people WHERE PROJECT = 'Plymouth';
EXECUTE
SELECT IDSTATE,EDUCATION FROM people WHERE STATE = 'VT';
EXECUTE
SELECT BIRTHCITY,PROJECT,HEIGHT FROM people WHERE STATE = 'ME';
EXECUTE
SELECT SSN,DEPENDENTS FROM people WHERE BIRTHCOUNTRY = 'Italy';
EXECUTE
