Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
course table
section table
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 18Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started