MSCI interview question

Do I know how to code this or that in SQL