Avaloq interview question

Basic SQL type Avaloq Scripts' logic/api explanation