Each twin has a status code called event
. The
query shown here is used to select all twin pairs combined by
event. This indicates in how many pairs both twins are finished,
in how many pairs one twin is finished and the other refused,
and so on.
SELECT t1.event, t2.event, COUNT(*) FROM lentus AS t1, lentus AS t2, twin_project AS tp WHERE /* We are looking at one pair at a time */ t1.id = tp.id AND t1.tvab=tp.tvab AND t1.id = t2.id /* Just the screening survey */ AND tp.survey_no = 5 /* This makes each pair only appear once */ AND t1.tvab='1' AND t2.tvab='2' GROUP BY t1.event, t2.event;
User Comments
Add your own comment.