SQL查询:如何选择记录，但如果父记录存在，则选择它最近的子记录

I have a complicated query I need to figure out but I'm not well versed enough in writing queries and sub queries.I have a complicated query I need to figure out