TUI Group interview question

Asked about SQL join conditions.