[Babase] Finding intergroup interactions
Karl O. Pinc
kop at meme.com
Mon Apr 19 11:48:47 EDT 2010
FYI
I get an overall not-in-the-same-supergroup to
total interaction ratio of 5689 / 744082,
or about 0.76%.
On 04/19/2010 10:31:01 AM, Karl O. Pinc wrote:
>
> SELECT interact.iid, interact.act, interact.date
> , actor.sname, supergroup(actorgrp.gid, interact.date) as
> actorsupergroup
> , actee.sname, supergroup(acteegrp.gid, interact.date) as
> acteesupergroup
> , 'Warning: Interactions should be between individuals in the
> same
> supergroup'
> FROM interact, parts AS actor, parts AS actee
> , members AS acteembr, members AS actormbr
> , groups AS acteegrp, groups AS actorgrp
> WHERE actor.iid = interact.iid
> AND actor.role = 'R'
> AND actormbr.date = interact.date
> AND actormbr.sname = actor.sname
> AND actorgrp.gid = actormbr.grp
> AND actee.iid = interact.iid
> AND actee.role = 'E'
> AND acteembr.date = interact.date
> AND acteembr.sname = actee.sname
> AND acteegrp.gid = acteembr.grp
> AND supergroup(actorgrp.gid, interact.date)
> != supergroup(acteegrp.gid, interact.date)
> ORDER BY interact.date, interact.act, interact.iid, actor.sname,
> actee.sname;
Karl <kop at meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
More information about the Babase
mailing list