Colliers Interview Question

questions regarding SQL