Question
<A calculation of number of students enrolled in section>
<A calculation of number of students enrolled in section / capacity, formatted at pct>
STU-COURSE NUMBER (8) VARCHAR2 (50 BYTE) NUMBER (9.2) COURSE_NO DESCRIPTION COST PREREQUISITE NUMBER (8) CREATED_BY CREATED_DATE DATE MODIFIED_BY MODIFIED DATE DATE VARCHAR2 (30 BYTE) VARCHAR2 (30 BYTE) CRSE_PK(COURSE NO) CRSE_CRSE_FK (PREREQUISITE) CRSE-CRSE-FK-I (PREREQUISITE) CRSE-PK(COURSE-NO) STU.SECTION STU ENROLLMENT STU STUDENT P SECTION ID UF COURSE NO U SECTIONNO NUMBER (8) NUMBER (8) NUMBER (3) STUDENT ID SALUTATION FIRST_NAME LASTNAME STREET_ADDRESS NUMBER (8) VARCHAR2 (5 BYTE) VARCHAR2 (25 BYTE VARCHAR2 (25 BYTE) VARCHAR2 (50 BYTE) VARCHAR2 (5 BYTE) VARCHAR2 (15 BYTE) VARCHAR2 (50 BYTE) PF" STUDENT ID PF" SECTION ID NUMBER (8) NUMBER (8) ENROLL_DATE DATE - START DATE TIME DATE LOCATION FINAL_GRADE CREATED_BY CREATED_DATE DATE NUMBER (3) VARCHAR2 (30 BYTE) - VARCHAR2 (50 BYTE) NUMBER (8) NUMBER (3) VARCHAR2 (30 BYTE) DATE VARCHAR2 (30 BYTE) DATE INSTRUCTOR_ID ZIP CAPACITY CREATED_BY CREATED_DATE MODIFIED BY MODIFIED_DATE PHONE EMPLOYER REGISTRATION DATE DATE CREATED_BY CREATED DATE MODIFIED_BY MODIFIED_DATE MODIFIED_BY VARCHAR2 (30 BYTE) MODIFIED_DATE DATE ENR_PK (STUDENT ID, SECTION ID) ENR_SECT_FK (SECTION_ID) ENR STU_FK (STUDENT ID) ENR-PK (STUDENT-ID, SECTION-ID) ENR-SECT-FKI (SECTION-ID) VARCHAR2 (30 BYTE) DATE VARCHAR2 (30 BYTE) DATE SECT PK (SECTION ID) SECT-SECT2-UK (SECTION-NO, COURSE-NO) STU_PK (STUDENT_ID) STU-PK (STUDENT-ID) SECT_CRSE_FK (COURSE_NO) SECT-CRSE-FK-1 (COURSE-NO) SECT-INST-FK-1(INSTRUCTOR-ID) SECT-PK (SECTION-ID) SECT-SECT2,UK (SECTION-NO, COURSE-NO)
Explanation / Answer
Select a.course_no, a.description, a.section_no, a.capacity,a.total_students, (a.total_students/a.capacity)100 as percentage_of_student ( select c.course_no, c.description, s.section_no,s.capacity, count() as total_students from stu.student s inner join stu.enrollment e on s.student_id = e.student_id inner join stu.section ss on e.section_id= ss.student_id inner join stu.course c on ss.course_no = c.couse_no group by c.couse_no,c.description, s.section_no, s.capacity ) a
