SQL Developer

List all pairs of sessions that have the same enrollment. The result should contain three columns such that and have the same enrollment number. A pair should appear only once in the output. (Tip: this is a self-join)

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)