please provide more details: a) what is the rule to choose the end_date? For the 1st record in your output, why did you choose "9/20/2024" instead of "5/17/2024" which is the date associated with "Seatle" (2nd row from input)? b) why does your output return the 3rd record, with "Dalas" and "Dalas"? considering that for "Las Vegas"(as physical) you didn't create a similar record (LA and LA). I believe that the 3rd record should not exist.