USER http://dig.csail.mit.edu/2009/IARPA-PIR/test/amy.n3
SELECT ENTRYDATE,BANKACCOUNT,LASTNAME FROM people WHERE STATE = 'VT';
EXECUTE
SELECT SECURITYANSWER,SUFFIX,WORKPHONE FROM people WHERE MIDDLENAME = 'James';
EXECUTE
SELECT SUFFIX,HOMEEMAIL FROM people WHERE BIRTHYEAR = 1902;
EXECUTE
SELECT SECURITYANSWER,ETHNICITY,STATE FROM people WHERE MIDDLENAME = 'Maria';
EXECUTE
SELECT BIRTHCITY,SSN FROM people WHERE HEIGHT = 78;
EXECUTE
SELECT FIRSTNAME,EDUCATION,STATE FROM people WHERE BIRTHYEAR = 1933;
EXECUTE
SELECT DOB,ADDRESS FROM people WHERE STATE = 'PA';
EXECUTE
SELECT RELIGION,SECURITYQUESTION,EDUCATION FROM people WHERE STATE = 'VT';
EXECUTE
SELECT INTERESTS,WEIGHT FROM people WHERE STATE = 'MA';
EXECUTE
SELECT RELIGION,MOBILEPHONE FROM people WHERE LASTNAME = 'Lopez';
EXECUTE
SELECT MOBILEPHONE FROM people WHERE WEIGHT = 249;
EXECUTE
SELECT BIRTHYEAR FROM people WHERE STATE = 'RI';
EXECUTE
SELECT FIRSTNAME FROM people WHERE LASTNAME = 'Ross';
EXECUTE
SELECT INTERESTS,BIRTHYEAR FROM people WHERE MIDDLENAME = 'Monica';
EXECUTE
SELECT STATE FROM people WHERE BIRTHYEAR = 1904;
EXECUTE
SELECT CITIZENSHIP,RELIGION,BANKACCOUNT FROM people WHERE LASTNAME = 'Myers';
EXECUTE
SELECT CERTIFICATION,MIDDLENAME FROM people WHERE STATE = 'CT';
EXECUTE
SELECT ETHNICITY,MIDDLENAME FROM people WHERE STATE = 'ME';
EXECUTE
SELECT BIRTHCITY,ENTRYDATE,BIRTHYEAR FROM people WHERE STATE = 'NJ';
EXECUTE
SELECT MIDDLENAME FROM people WHERE STATE = 'CT';
EXECUTE
SELECT FIRSTNAME,CITIZENSHIP,BIRTHCOUNTRY FROM people WHERE BIRTHYEAR = 1961;
EXECUTE
SELECT HEIGHT FROM people WHERE STATE = 'PA';
EXECUTE
SELECT LASTNAME FROM people WHERE STATE = 'CT';
EXECUTE
SELECT BIRTHCITY,FIRSTNAME FROM people WHERE STATE = 'CT';
EXECUTE
SELECT BANKACCOUNT,BIRTHCOUNTRY FROM people WHERE FIRSTNAME = 'Susan';
EXECUTE
SELECT BANKACCOUNT FROM people WHERE MIDDLENAME = 'Cynthia';
EXECUTE
SELECT BIRTHCOUNTRY,TITLE,FIRSTNAME FROM people WHERE STATE = 'CT';
EXECUTE
SELECT HOMEEMAIL,BANKACCOUNT,COUNTRY FROM people WHERE STATE = 'CT';
EXECUTE
SELECT GENDER,EYECOLOR,HOMEPHONE FROM people WHERE BIRTHYEAR = 1903;
EXECUTE
SELECT USERNAME,SUFFIX,BANKACCOUNT FROM people WHERE STATE = 'RI';
EXECUTE
SELECT EDUCATION,MOBILEPHONE FROM people WHERE LASTNAME = 'Green';
EXECUTE
SELECT BANKACCOUNT FROM people WHERE STATE = 'RI';
EXECUTE
SELECT IDSTATE,SUFFIX,EDUCATION FROM people WHERE STATE = 'MA';
EXECUTE
SELECT USERNAME FROM people WHERE FIRSTNAME = 'Richard';
EXECUTE
SELECT USERNAME FROM people WHERE FIRSTNAME = 'Alan';
EXECUTE
SELECT HEIGHT,HOMEPHONE FROM people WHERE LASTNAME = 'Marshall';
EXECUTE
SELECT HOMEPHONE,INTERESTS FROM people WHERE WEIGHT = '213';
EXECUTE
SELECT GENDER,BIRTHCITY,SUFFIX FROM people WHERE MIDDLENAME = 'Angela';
EXECUTE
SELECT MIDDLENAME FROM people WHERE LASTNAME = 'Rodriguez';
EXECUTE
SELECT DOB,GENDER FROM people WHERE FIRSTNAME = 'Victor';
EXECUTE
SELECT CITIZENSHIP,LASTNAME,MOBILEPHONE FROM people WHERE STATE = 'NY';
EXECUTE
SELECT ETHNICITY,SUFFIX,WORKEMAIL FROM people WHERE WEIGHT = '111';
EXECUTE
SELECT LASTNAME,ADDRESS FROM people WHERE MIDDLENAME = 'Phillip';
EXECUTE
SELECT COUNTRY,SECURITYQUESTION,GENDER FROM people WHERE FIRSTNAME = 'Justin';
EXECUTE
SELECT PUBLICKEYHASH,SSN FROM people WHERE STATE = 'CT';
EXECUTE
SELECT SECURITYQUESTION FROM people WHERE INTERESTS = 'San Jose Earthquakes |Portland Trail Blazers ';
EXECUTE
SELECT WORKPHONE FROM people WHERE FIRSTNAME = 'Linda';
EXECUTE
SELECT EDUCATION,INTERESTS FROM people WHERE STATE = 'CT';
EXECUTE
SELECT EYECOLOR,DOB FROM people WHERE MIDDLENAME = 'Maria';
EXECUTE
SELECT FIRSTNAME FROM people WHERE LASTNAME = 'Ward';
EXECUTE
SELECT WEIGHT,BIRTHCOUNTRY,RELIGION FROM people WHERE FIRSTNAME = 'Maria';
EXECUTE
SELECT WORKEMAIL FROM people WHERE MIDDLENAME = 'Eric';
EXECUTE
SELECT DEPENDENTS,HEADSHOT FROM people WHERE HEIGHT = '67';
EXECUTE
SELECT SSN,EDUCATION,SECURITYANSWER FROM people WHERE BIRTHYEAR = 1906;
EXECUTE
SELECT PASSWORD,CITIZENSHIP FROM people WHERE FIRSTNAME = 'Lawrence';
EXECUTE
SELECT DIRECTDEPOSIT,BIRTHCITY FROM people WHERE HEIGHT = '71';
EXECUTE
SELECT STATE,SECURITYQUESTION,BIRTHSTATE FROM people WHERE BIRTHCITY = 'INDIANAPOLIS';
EXECUTE
SELECT RELIGION,CERTIFICATION,IDSTATE FROM people WHERE ETHNICITY = 'White';
EXECUTE
SELECT USERNAME,DIRECTDEPOSIT FROM people WHERE BIRTHYEAR = 1967;
EXECUTE
SELECT USERNAME,SSN,HEADSHOT FROM people WHERE BIRTHYEAR = 1916;
EXECUTE
SELECT PROJECT,HEADSHOT FROM people WHERE BIRTHYEAR = 1929;
EXECUTE
SELECT CERTIFICATION,EYECOLOR FROM people WHERE BIRTHYEAR = 1902;
EXECUTE
SELECT LASTNAME,HAIRCOLOR FROM people WHERE BIRTHYEAR = 1915;
EXECUTE
SELECT WEIGHT FROM people WHERE BIRTHYEAR = 1905;
EXECUTE
SELECT ENTRYDATE,COUNTRY,EDUCATION FROM people WHERE LASTNAME = 'Clark';
EXECUTE
SELECT DEPENDENTS,MARITALSTATUS,FIRSTNAME FROM people WHERE BIRTHYEAR = 1920;
EXECUTE
SELECT ADDRESS,RELIGION FROM people WHERE BIRTHYEAR = 1926;
EXECUTE
SELECT EYECOLOR,COUNTRY,FIRSTNAME FROM people WHERE MIDDLENAME = 'Virginia';
EXECUTE
SELECT TITLE FROM people WHERE MIDDLENAME = 'Martin';
EXECUTE
SELECT TITLE,ENTRYDATE,PASSWORDHASH FROM people WHERE FIRSTNAME = 'Sarah';
EXECUTE
SELECT FIRSTNAME,USERNAME,RELIGION FROM people WHERE FIRSTNAME = 'Craig';
EXECUTE
SELECT RELIGION,USERNAME FROM people WHERE BIRTHYEAR = 1904;
EXECUTE
SELECT WORKPHONE FROM people WHERE FIRSTNAME = 'James';
EXECUTE
SELECT PROJECT,MIDDLENAME FROM people WHERE BIRTHCITY = 'SACRAMENTO';
EXECUTE
SELECT INTERESTS FROM people WHERE MIDDLENAME = 'Florence';
EXECUTE
SELECT BIRTHYEAR FROM people WHERE BIRTHYEAR = 1908;
EXECUTE
SELECT PUBLICKEYHASH,GENDER FROM people WHERE MIDDLENAME = 'Shannon';
EXECUTE
SELECT FINGERPRINT FROM people WHERE MIDDLENAME = 'Earl';
EXECUTE
SELECT USERNAME,TITLE FROM people WHERE BIRTHYEAR = 1921;
EXECUTE
SELECT BIRTHYEAR,SUFFIX,COUNTRY FROM people WHERE BIRTHYEAR = 1917;
EXECUTE
SELECT SECURITYANSWER,STATE,DIRECTDEPOSIT FROM people WHERE PROJECT = 'Wight';
EXECUTE
SELECT FINGERPRINT FROM people WHERE BIRTHYEAR = 1922;
EXECUTE
SELECT DOB,BIRTHCITY FROM people WHERE CITIZENSHIP = 'USA';
EXECUTE
SELECT DOB FROM people WHERE BIRTHYEAR = 1911;
EXECUTE
SELECT MOBILEPHONE FROM people WHERE HEIGHT = '69';
EXECUTE
SELECT WORKPHONE FROM people WHERE BIRTHYEAR = 1901;
EXECUTE
SELECT COUNTRY,ETHNICITY FROM people WHERE EYECOLOR = 'HAZ';
EXECUTE
SELECT PASSWORD,LASTNAME FROM people WHERE BIRTHYEAR = 1909;
EXECUTE
SELECT RELIGION FROM people WHERE WEIGHT = '154';
EXECUTE
SELECT WEIGHT FROM people WHERE BIRTHYEAR = 1922;
EXECUTE
SELECT IDSTATE,BIRTHCOUNTRY,ETHNICITY FROM people WHERE FIRSTNAME = 'Kenneth';
EXECUTE
SELECT HOMEEMAIL FROM people WHERE FIRSTNAME = 'Julia';
EXECUTE
SELECT LASTNAME FROM people WHERE MIDDLENAME = 'Robert';
EXECUTE
SELECT IDSTATE,PUBLICKEYHASH FROM people WHERE BIRTHYEAR = 1927;
EXECUTE
SELECT BANKACCOUNT,EYECOLOR FROM people WHERE BIRTHYEAR = 1926;
EXECUTE
SELECT ETHNICITY,IDNUMBER,SECURITYANSWER FROM people WHERE BIRTHYEAR = 1928;
EXECUTE
SELECT IDNUMBER,EDUCATION,FIRSTNAME FROM people WHERE CITIZENSHIP = 'USA';
EXECUTE
SELECT WORKEMAIL,ETHNICITY FROM people WHERE MIDDLENAME = 'Jason';
EXECUTE
SELECT LASTNAME,DEPENDENTS FROM people WHERE IDSTATE = 'WY';
EXECUTE
SELECT BIRTHCITY,MOBILEPHONE FROM people WHERE FIRSTNAME = 'Anna';
EXECUTE
