← Morgan Stanley questions

SQL query to join tables and filter

Filed under Morgan Stanley

Given two tables, 'Employees' (id, name, dept_id) and 'Departments' (id, name), write a SQL query to return the names of all employees and their corresponding department names, filtering for…

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.