uni/COMP2400/q6.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

TTITLE "COMP2400: Assignment 1: Question 6"

SELECT motherid, fatherid
FROM parents
GROUP BY motherid, fatherid
HAVING COUNT(personid) = (SELECT MAX(COUNT(personid))
                          FROM parents
                          GROUP BY motherid, fatherid);

EXIT;
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	apollock	1.2	TTITLE "COMP2400: Assignment 1: Question 6"
8
9	apollock	1.1	SELECT motherid, fatherid
10			FROM parents
11			GROUP BY motherid, fatherid
12			HAVING COUNT(personid) = (SELECT MAX(COUNT(personid))
13			FROM parents
14			GROUP BY motherid, fatherid);
15	apollock	1.2
16			EXIT;