Take data from Lead Record when condition or filter criteria matches and ignore the records between current row and selected record (lead row)
How can I write a CTE in SQL Server to get the date from the preceding row for the person that has Type = NA.