DataArt interview question

SQL question which I'm not familiar to.