uni/COMP2400/q5.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 5"

SELECT motherid, fatherid, COUNT(personid) AS children
FROM parents
GROUP BY motherid, fatherid;

EXIT;
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	TTITLE "COMP2400: Assignment 1: Question 5"
8
9	SELECT motherid, fatherid, COUNT(personid) AS children
10	FROM parents
11	GROUP BY motherid, fatherid;
12
13	EXIT;