+----------+-----------+------------+------+
| group_id | person_id | is_primary | year |
+----------+-----------+------------+------+
| aaa      |         1 | TRUE       | 2000 |
| aaa      |         1 | TRUE       | 2001 |
| aaa      |         1 | TRUE       | 2002 |
| aaa      |         1 | TRUE       | 2003 |
| aaa      |         1 | TRUE       | 2004 |
| bbb      |         2 | TRUE       | 2000 |
| bbb      |         2 | TRUE       | 2001 |
| bbb      |         2 | TRUE       | 2002 |
| bbb      |         3 | FALSE      | 2000 |
| bbb      |         3 | FALSE      | 2001 |
+----------+-----------+------------+------+

+----------+-----------+------------+------+-------------+
| group_id | person_id | is_primary | date |   rand_no   |
+----------+-----------+------------+------+-------------+
| aaa      |         1 | TRUE       | 2000 | 0.831621612 |
| aaa      |         1 | TRUE       | 2001 | 0.831621612 |
| aaa      |         1 | TRUE       | 2002 | 0.831621612 |
| aaa      |         1 | TRUE       | 2003 | 0.831621612 |
| aaa      |         1 | TRUE       | 2004 | 0.831621612 |
| bbb      |         2 | TRUE       | 2000 | 0.112331317 |
| bbb      |         2 | TRUE       | 2001 | 0.112331317 |
| bbb      |         2 | TRUE       | 2002 | 0.112331317 |
| bbb      |         3 | FALSE      | 2000 | 0.112331317 |
| bbb      |         3 | FALSE      | 2001 | 0.112331317 |
+----------+-----------+------------+------+-------------+