Students Roster name lastname age ID ID major absence rim ismail 19 123 123 EE 4. sara kamel 18 134 134 EE milad ghantous 21 1345 1345 CCE 2 tarek dib 18 12345 12345 ME 4 Complete this query that...

Computer science

Extracted text: Students Roster name lastname age ID ID major absence rim ismail 19 123 123 EE 4. sara kamel 18 134 134 EE milad ghantous 21 1345 1345 CCE 2 tarek dib 18 12345 12345 ME 4 Complete this query that finds all student ID pairs that have same number of absences. Select one: O SELECT ID1, ID2 FROM roster WHERE absence1= absence2 and ID1 ID2 OSELECT roster.ID, students.ID. absence FROM roster, students WHERE roster.ID%3Dstudents.ID O. SELECTr1.ID. r2.1D FROM rosterrt roster r2 WHERE r1.absence-r2.absence O SELECT r1ID.r2,ID FROM roster r1, roster r2 WHERE r1.absence= r2.absence and r1.ID r2 ID