| 4 |
-- work. It has not been produced, in whole or in part, by another person. |
-- work. It has not been produced, in whole or in part, by another person. |
| 5 |
-- (signed) Andrew Pollock 4137129 |
-- (signed) Andrew Pollock 4137129 |
| 6 |
|
|
| 7 |
|
TTITLE "COMP2400: Assignment 1: Question 6" |
| 8 |
|
|
| 9 |
SELECT motherid, fatherid |
SELECT motherid, fatherid |
| 10 |
FROM parents |
FROM parents |
| 11 |
GROUP BY motherid, fatherid |
GROUP BY motherid, fatherid |
| 12 |
HAVING COUNT(personid) = (SELECT MAX(COUNT(personid)) |
HAVING COUNT(personid) = (SELECT MAX(COUNT(personid)) |
| 13 |
FROM parents |
FROM parents |
| 14 |
GROUP BY motherid, fatherid); |
GROUP BY motherid, fatherid); |
| 15 |
|
|
| 16 |
|
EXIT; |
Parent Directory
| 
Revision Log
| 
Patch