Help Needed Urgent with SQL Query

[tranz125]

Hello,

I have the following scenario please help:

i have my source data as::

DEL STATUS TIMESTAMP EVENT

D1 ACT JAN 13 audit
D1 CURE JAN 23 CURRENT



MY TARGET TABLLE MUST HAVE DATA IN THSI FORMAT:

DEL STATUS EFFECTIVE_DATE END_DATE

D1 ACT JAN 13 JAN 23
D1 CURE JAN23 NULL


I am trying to write a SQL to implement it please help me or give your suggestions to implement it.


Thanks