1 
 I have read the ANU Code on "Academic Honesty in Learning and Teaching", 
2 
 and I declare that, except where appropriately attributed, the content 
3 
 of the file I have submitted for this assignment is entirely my own 
4 
 work. It has not been produced, in whole or in part, by another person. 
5 
 (signed) Andrew Pollock 4137129 
6 

7 
SELECT fatherid as grandparent 
8 
FROM parents 
9 
WHERE personid in ( 
10 
SELECT fatherid as parent 
11 
FROM parents 
12 
WHERE personid = '&1' 
13 
UNION 
14 
SELECT motherid as parent 
15 
FROM parents 
16 
WHERE personid = '&1') 
17 
UNION 
18 
SELECT motherid as grandparent 
19 
FROM parents 
20 
WHERE personid in ( 
21 
SELECT fatherid as parent 
22 
FROM parents 
23 
WHERE personid = '&1' 
24 
UNION 
25 
SELECT motherid as parent 
26 
FROM parents 
27 
WHERE personid = '&1'); 