HSBC interview question

what is the SQL execution flow