Manager of the Largest Department - Amazon Interview Question - SQL
ฝัง
- เผยแพร่เมื่อ 6 ต.ค. 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