Nomura interview question

SQL - related questions