ACI Worldwide interview question

Some SQL related query