Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- STUD STUDENT_NAME ENROLL_ID STUD CLASS_ID CLASS_GRADE
- ---- ------------------------- -------------- ---- ---------- -----------
- CLASS_ID CLASS_NAME
- ---------- ---------------------------------------------------------------
- 5015 John 5015282001 5015 282001 89
- 282001 Database
- 5015 John 5015100001 5015 100001 93
- 100001 Intro
- 5015 John 5015305001 5015 305001 92
- 305001 Data Structures
- STUD STUDENT_NAME ENROLL_ID STUD CLASS_ID CLASS_GRADE
- ---- ------------------------- -------------- ---- ---------- -----------
- CLASS_ID CLASS_NAME
- ---------- ---------------------------------------------------------------
- 5737 Tara 5737282001 5737 282001 56
- 282001 Database
- 5737 Tara 5737100001 5737 100001 60
- 100001 Intro
- 3751 Tim 3751305001 3751 305001 93
- 305001 Data Structures
- STUD STUDENT_NAME ENROLL_ID STUD CLASS_ID CLASS_GRADE
- ---- ------------------------- -------------- ---- ---------- -----------
- CLASS_ID CLASS_NAME
- ---------- ---------------------------------------------------------------
- 4612 Angel 4612100001 4612 100001 88
- 100001 Intro
- 4612 Angel 4612305001 4612 305001 91
- 305001 Data Structures
- 8 rows selected.
- STUDENT_NAME
- ------------------------
- John
- Tim
- Angel
- AVERAGE
- ----------
- 80.3333333
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement