On szip zzip where zstate ct order by students 5 find

This preview shows page 1 - 3 out of 5 pages.

ON s.ZIP = z.ZIP WHERE z.STATE = ‘CT’ ORDER BY STUDENTS;
5. Find the minimum, maximum, and average grade of final exams in sections taught by Todd Smythe.
6. For all students who took "Intro to Information Systems", calculate the highest, lowest, and average midterm exam grade for each section. Display Section No and calculation results. SELECT s.SECTION_NO, MAX (g.NUMERIC_GRADE) AS MAX, MIN (g.NUMERIC_GRADE) AS MIN, AVG (g. NUMERIC_GRADE) AS AVG FROM GRADE g, STUDENT st, SECTION s, COURSE c WHERE c.DESCRIPTION = ‘Intro to Information Systems’ AND g.GRADE_TYPE_CODE = ‘MT’ AND s.SECTION_ID=g.SECTION_ID AND st.STUDENT_ID=g.STUDENT_ID AND s.COURSE_NO = c.Course_NO GROUP BY s.SECTION_NO; 7. List the instructor id and name of the instructors that teach fewer than 10 sections regardless of student enrollment.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture