title: SQL query that reports N or more consecutive absents from attendance table
body: <p>I have a table that looks like this:</p>
  
  <pre><code>studentID | subjectID | attendanceStatus | classDate  | classTime | lecturerID |
  12345678    1234        1                  2012-06-05   15:30:00
  87654321
  12345678    1234        0                  2012-06-08   02:30:00
  </code></pre>
  
  <p>I want a query that reports if a student has been absent for 3 or more <em>consecutive classes.</em> based on studentID and a specific subject between 2 specific dates as well. Each class can have a different time. The schema for that table is:</p>
  
  <pre><code>PK(`studentID`, `classDate`, `classTime`, `subjectID, `lecturerID`)
  </code></pre>
  
  <p>Attendance Status: 1 = Present, 0 = Absent</p>
  
  <p>Edit: Worded question so that it is more accurate and really describes what was my intention.</p>