Relay-Version: version B 2.10 5/3/83; site utzoo.UUCP
Path: utzoo!utgpu!water!watmath!clyde!cbosgd!ihnp4!homxb!mtuxo!mtune!rutgers!ukma!psuvm.bitnet!uh2
From: uh2@psuvm.bitnet.UUCP
Newsgroups: comp.databases
Subject: RBASE Mysteries
Message-ID: <23860UH2@PSUVM>
Date: Fri, 30-Oct-87 16:01:51 EST
Article-I.D.: PSUVM.23860UH2
Posted: Fri Oct 30 16:01:51 1987
Date-Received: Sun, 1-Nov-87 09:38:02 EST
Organization: The Pennsylvania State University - Computation Center
Lines: 15

I have an embarrassingly simple RBASE System V problem.
     
Spose I've got a table SCG(StudentId, CourseId, Grade) where
the Grade is a numerical equivalent, say A=4, B=3, C=2, etc.  SCG
contains the grade that a student got in a course.
     
I want to construct a new table, SG( StudentId, GPA), as in
     
   Select StudentId avg(Grade)
   From SCG
   Group By StudentId
     
How is this accomplished with RBASE?
     
Lee