Leetcode - 1076. Project Employees II

문제

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

정답

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
)