Tuning query to remove joins for reporting
No it wouldn't (that is, it's not logically equivalent. Performance would probably be better though). Two reasons:


Both of the subqueries are aggregating to get the minimum event_date.
The second subquery (join_223) is an OUTER JOIN, not an INNER JOIN.


Incidentally, you have a repeated ON ON in the last line of the original query.