Colliers interview question

questions regarding SQL