UBS Interview Question

Sql query optimization, data flow etc