Leetcode - 1076. Project Employees II

Table of Contents

정답

문제

[Loading...

Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.

LeetCode

](https://leetcode.com/problems/project-employees-ii/description/)

정답

SELECT project_id
FROM (
    SELECT project_id, COUNT(*) as count FROM Project
    GROUP BY project_id
) AS Temp1
WHERE count IN (
    SELECT MAX(count)
    FROM (
        SELECT COUNT(*) as count FROM Project
        GROUP BY project_id
    ) AS Temp2
)