Research for the verification of a procedure if two actions happened

Hello,

I have a table with a varchar2 field where a certain action is registered and a date field, where the date and time of the action is registered.

I have to do a survey that checks if a certain procedure happened. For this, it is necessary that 2 certain actions have happened one after the other, not necessarily right after the other.

Example:

Date Action

---------------------------------

xx/xx/xx A1

...

...

xx/xx/xx A2 - procedure happened

Date Action

--------------------------------

xx/xx/xx a1

....

....

xx/xx/xx a1 - As action a2 did not take place, the procedure did not take place.