SQL Developer CourseSession Enrollment ses ID: NUMBER(6) ses date: DATE Course %

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

SQL query to list the participants who have not enrolled in a course session with the course_number ‘TAT’ (Use NOT EXISTS).

select * from Participant
where NOT EXISTS (select * from Enrollment
where Participant.part_ID = Enrollment.part_ID and Enrollment.ses_ID IN
(select ses_ID from CourseSession where course_number = 'TAT'));

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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