Consecutive rows query

[brat15]

Hey,
I trying to write a query which results in all students who have been absent for 2 consecutive classes and 3 consecutive classes. Is there any examples of this kind.

Thanks

 

[JamesLean]

It might help if you gave us a bit more to go on - table structures, example data, results required etc...

--James

 

[brat15]

The major tables i think we need are

TS_Appointment - The appointment details are here
Appointment_Id
StudentTerm_Id_FK
TutorTimeSlot_Id_FK
AppointmentStatus_Id_FK
TS_TutorTimeSlot - The Appointments available for each tutor
TutorTimeSlot_Id
TutorTimeSlot_day
TutorTerm_Id_FK

TS_StudentTerm
StudentTerm_Id
StudentId_Fk

I need to have all students that have missed a session with a tutor two times in a row and 3 times in a row,
for the same student with the same tutor.

The result should be like

StudentName, Tutor, Day, Date


Any help will be appreciated