Domanda di colloquio di Russell Investments

what would be the sql script for this?