Lloyds Banking Group Interview Question

Asked me to do a lengthy SQL query that linked several flights together