Input andrewID, finger andrewID at unix.andrew.cmu.edu

Open Database: locaccino.org database pf2

username:  harraton
password:  ilx26_galaxy



Joined the study:
select user.facebookID, user.firstname,
user.lastname from user, condition_membership where user.uid =
condition_membership.user_uid where user.lastname = 'LAST NAME' and
user.firstname = 'FIRSTNAME';


If empty set then append andrewid on Not Joined list.

Send Location:
SELECT
user.lastname from Location, LocationContext, ContextInfo, User,
condition_membership where Location.locID =
LocationContext.location_locID and LocationContext.contextID =
ContextInfo.contextID and ContextInfo.owner_UID = User.UID and user.uid
= condition_membership.user_uid group where user.lastname = 'LAST NAME'
and user.firstname = 'FIRSTNAME';


If empty set, then append andrewID on SendingLocation list.

Rules:

Select
user.lastname, count(*) as 'NumRules' from user, rule,
condition_membership where user.uid = rule.owner_uid and user.uid =
condition_membership.user_uid where user.lastname = 'LAST NAME' and
user.firstname = 'FIRSTNAME';


If empty set, then append andrewID on No Rules list.

Print the Not Joined, SendingLocation and No Rules lists to a file.