TUI Group Interview Question

Asked about SQL join conditions.