SQL> desc grade;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------

 IDNO                                               VARCHAR2(3)
 NAME                                               VARCHAR2(25)
 GRADELEVEL                                         NUMBER(2)

SQL> select * from grade;

IDN NAME                      GRADELEVEL
--- ------------------------- ----------
111 Susan Ash                          4
122 David Costa                       11
123 Linda French                       7

SQL> desc schools;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------

 SCHOOLNO                                           VARCHAR2(3)
 GROUPNAME                                          VARCHAR2(25)
 LOWGRADE                                           NUMBER(2)
 HIGHGRADE                                          NUMBER(2)

SQL> select * from schools;

SCH GROUPNAME                   LOWGRADE  HIGHGRADE
--- ------------------------- ---------- ----------
100 South Elementary                   1          6
200 East Middle                        7          8
300 Durfee High                        9         12


SQL> select grade.name, grade.gradelevel, schools.groupname
  2  from grade, schools
  3  where grade.gradelevel between schools.lowgrade and schools.highgrade;

NAME                      GRADELEVEL GROUPNAME
------------------------- ---------- -------------------------
David Costa                       11 Durfee High
Linda French                       7 East Middle
Susan Ash                          4 South Elementary