SQL Developer CourseSession Enrollment ses ID: NUMBER(6) ses date: DATE Course %
ID: 3747147 • Letter: S
Question
SQL Developer CourseSession Enrollment ses ID: NUMBER(6) ses date: DATE Course % part ID: NUMBER(6)(FK) has, ses ID NUMBER(6) (F relates to enroll_attending: CHAR(1) offered throughcourse number: VARCHAR(5) based orn ses time: VARCHAR10) ses roomNumber: VARCHAR(S) ses enrollmentNumber. NUMBER(3) course number: VARCHAR(5) (FK) course-name VARCHAR(50) course description: VARCHAR(650) course capacity: NUMBER(3) enrolls with / isfor Participant part ID: NUMBER(6) VolunteeringTime part fName: VARCHAR(100) part IName: VARCHAR(100) part address: VARCHAR(200) part_city: VARCHAR(100) part zipcode: NUMBER(5) part _phone: VARCHAR(20) part_ email: VARCHAR(50) (AK1.1) part_dateOYBirth: DATE part ID NUMBER)(FK) volTime arrivalTime: DATE volTime_leaveTime: DATE volTime date: DATE volunteers and captures times in / recordings volunteering time from volTime durationinMinutes: NUMBER(3) BikeType gets bike through gives bike to btype_ID: NUMBER(4) btype name: VARCHAR(20) Bike bike serialNumber: NUMBER(6) bike_name: VARCHAR(40) GiveAway categohizes/ categorized in giveaway ID: NUMBER(6) giveaway _date: DATE part ID: NUMBER(6) (FK) bike serialNumber: NUMBER(6) (FK) is given away through gives away bike brand: VARCHAR(50) bike sizelninches: NUMBER(2) bike condition: VARCHAR(20) bike volunteerTimelnHrReq: NUMBER(4) bike comment: VARCHAR(350) btype _ID: NUMBER (FK)Explanation / Answer
Q1) List the course numbers, name, and capacity of courses without enrollments. Use a MINUS operator.
SELECT Course.Course_Number, Course.Course_Name, Course.Course_Capacity from Course JOIN CourseSession ON Course.Course_Number = CourseSession.Course_Number
MINUS
SELECT Course.Course_Number, Course.Course_Name, Course.Course_Capacity from Course JOIN CourseSession ON Course.Course_Number = CourseSession.Course_Number WHERE CourseSession.ses_enrollmentNumber IS NOT NULL;
Please let me know in case of any clarifications required. Thanks!
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.