uni/COMP2400/q7.sql

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

SELECT fatherid as grandparent
FROM parents
WHERE personid in (
SELECT fatherid as parent
FROM parents
WHERE personid = '&1'
UNION
SELECT motherid as parent
FROM parents
WHERE personid = '&1')
UNION
SELECT motherid as grandparent
FROM parents
WHERE personid in (
SELECT fatherid as parent
FROM parents
WHERE personid = '&1'
UNION
SELECT motherid as parent
FROM parents
WHERE personid = '&1');
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');