Manager of the Largest Department - Amazon Interview Question - SQL

Описание к видео Manager of the Largest Department - Amazon Interview Question - SQL

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

Комментарии

Информация по комментариям в разработке