Question: I have a three table course section and enrollment. Write a query of sections that still have room for enrollment. Give me a query with

I have a three table course section and enrollment.

Write a query of sections that still have room for enrollment. Give me a query with the following details: Course_no, description (from course), section_id, section_no, start_date_time, capacity, enrollment count, capacity_pct

enrollment table

I have a three table course section and enrollment. Write a querycourse table

of sections that still have room for enrollment. Give me a query section table

with the following details: Course_no, description (from course), section_id, section_no, start_date_time, capacity,

SECTION ID 4. ENROLL DATE STUDENT ID 102 102 103 104 105 MODIFIED BY MODIFIED DAT CREATED DATE 03-NOV-17 CBRENNAN 12-DEC-17 03-Nov-17 03-NOV-17 03-NOV-17 03-NOV-17 03-NOV-17 CBRENNAN 12-DEC-17 03-NOV-17 CBRENNAN 12-DEC-17 03-NOV-17 CBRENNAN 03-NOV-17 CBRENNAN 03-NOV-17 03-NOV-17 03-NOV-17 CBRENNAN 12-DEC-17 03-NOV-17 CBRENNAN 12-DEC-17 FINAL GRADE CREATED BY null) JAYCAF 86 30-JAN-17 89 30-JAN-17 81 30-JAN-17 1 30-JAN-17 155 30-JAN-17 9 30-JAN-17 101 30-JAN-17 87 30-JAN-17 86 30-JAN-17 99 30-JAN-17 101 30-JAN-17 95 02-FEB-17 154 02-FEB-17 133 02-FEB-17 142 02-FEB-17 95 02-FEB-17 154 02-FEB-17 128 02-FEB-17 92 JAYCAF (au11) JAYCAF 12-DEC-17 (null) JAYCAF (null) JAYCAF (null) JAYCAF (null) JAYCAF CBRENNAN12-DEC-17 106 107 12-DEC-17 12-DEC-17 12-DEC-17 10 109 109 110 110 17 CBRENNAN 12 (null) JAYCAF (null) JAYCAF (null) JAYCAF nul1) JAYCAF 12 13 03-OV-17 CBRENNA 12-DEC-17 15 03-NoV-17 03-NOV-17 03-NOV-17CBRENNAN 03-NOV-17 12-DEC-17 12-DEC-17 12-DEC-17 CBRENNAN12-DEC-17 17 CBRENNAN 12 112 112 113 nu11) JAYCAF (null) JAYCAF (null) JAYCAF 16 18

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!