Manager of the Largest Department - Amazon Interview Question - SQL
HTML-код
- Опубликовано: 22 июн 2024
- Given a list of a company's employees, find the name of the manager from the largest department. Manager is each employee that contains word "manager" under their position. Output their first and last name.
Companies appeared in: Amazon, Ebay, Shopify
Difficulty: Medium
Ideas: GROUP BY, Window Function
Nicely explained and guided for the people who wish to face the interview