0

I have the following table.

This is a very similar question to this, but I want to expand a bit more on what the original question is asking. I am fairly new to mySQL, so I've never really dealt with anything like this before.

I need to identify the records in which there are at least 3 consecutive semesters having:

units_enrolled = 0

I then need to assign an ID to the sequential groupings, but the ID must reset upon a new stdnt_id.

Lastly, I want to also indicate whether or not the student enrolls at some point after a pause.

Something like these results: Result set

Would this even be feasible in mySQL and on a large-scale basis?

Community
  • 1
  • 1
  • show your sample data ang expected result – Vijunav Vastivch Feb 03 '17 at 05:11
  • This question needs improving because either I interpret the question literally, then it is a yes / no question, or I interpret is as a code request (there is no own effort demonstrated), then I would have deem it as too broad. – Shadow Feb 03 '17 at 05:19
  • Btw, it is feasible in mysql, whether it is efficient on a large scale that's up to you to test. – Shadow Feb 03 '17 at 05:27

0 Answers0