[comp.databases] RBASE Mysteries

uh2@psuvm.bitnet.UUCP (10/31/87)

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