/[cvs.andrew.net.au]/uni/COMP2400/q5.sql
ViewVC logotype

Diff of /uni/COMP2400/q5.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.1 by apollock, Sat Aug 7 11:07:01 2004 UTC revision 1.2 by apollock, Tue Aug 10 01:28:52 2004 UTC
# Line 4  Line 4 
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 5"
8    
9  SELECT motherid, fatherid, COUNT(personid) AS children  SELECT motherid, fatherid, COUNT(personid) AS children
10  FROM parents  FROM parents
11  GROUP BY motherid, fatherid;  GROUP BY motherid, fatherid;
12    
13    EXIT;

Legend:
Removed from v.1.1  
changed lines
  Added in v.1.2

  ViewVC Help
Powered by ViewVC 1.1.22