Using a PARTITION BY JOIN to Fill In The Gaps in Sparse Data

Thanks, @lfor this worked too but still very slow due to the volume of data in table AUDIT_DATA.