2-List the course number and description of courses where in students have recei

Question

2-List the course number and description of courses where in students have received grades for every one of the possible grade types offered in the course. Order by course number.

4- List course number and description all of the Java courses and the total number of enrollments for each course. Arrange by course number. Show zero for courses with no students enrolled.

5-List student ID and Name of all of the students in area code 617 along with the number of enrollments each has. If the students has not enrolled in any courses, display the word “none” in the enrollments column.
Alphabetize the list on last name and first name.

Explanation / Answer

2) SELECT COURSE_NO,DESCRIPTION FROM COURSE A,SECTION B,GRADE_TYPE_CODE C WHERE A.COURSE_NO=B.COURSE_NO AND B.SECTION_ID=C.SECTION_ID AND GRADE_TYPE_CODE IN (SELECT DISTINCT GRADE_TYPE_CODE FROM GRADE_TYPE_WEIGHT)

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.