DataArt Interview Question

SQL question which I'm not familiar to.