INF 282 Assignment

SELECT s.*, e.*, c.* FROM
  stephensow1_Student s, stephensow1_Enroll e, stephensow1_Class c
  WHERE e.Student_ID = s.Student_ID AND
    e.Class_ID = c.Class_ID;

SELECT s.Student_Name FROM
  stephensow1_Student s, stephensow1_Enroll e
  WHERE e.Student_ID = s.Student_ID AND
    e.Class_ID = '305001';

SELECT SUM(Class_Grade) / 3 AS Average FROM stephensow1_Enroll
  WHERE Class_ID = '100001';