← Morgan Stanley questions

Employees earning more than their manager; swap gender values; employee count per departme

Filed under Morgan Stanley

Using employee, manager-relation and department tables, write SQL to find employees paid more than their manager, update male to female and vice versa, and count employees per department. Assumed…

You've read your 3 free write-ups

Sign up free to keep reading. Your account opens the first 10 questions of every company.

Related Morgan Stanley questions

Collected from public candidate posts and coding forums. Updated Nov 2026.