1 
apollock 
1.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'); 