I have a table of student actions (
quarter). I need to get a list of all the students, along w/ a flag of whether they had a particular action in the current quarter, and the past quarter but I'm not sure how to do this in Oracle SQL.
Assuming that the current quarter is 3, and that I'm only interested in the
Probation actions how would I get a result set like the one I've mocked up below?