This Leetcode problem Project Employees II LeetCode Solution is done in SQL.

List of all LeetCode Solution

Project Employees II LeetCode Solution

Problem Statement

Column Name	Type
project_id	int
employee_id	int

Table: Project

(project_id, employee_id) is the primary key of this table. employee_id is a foreign key to Employee table. Each row of this table indicates that the employee with employee_id is working on the project with project_id.

Column Name	Type
employee_id	int
name	varchar
experience_years	int

Table: Employee

employee_id is the primary key of this table. It’s guaranteed that experience_years is not NULL. Each row of this table contains information about one employee.

Write an SQL query that reports all the projects that have the most employees.

The query result format is in the following example:

Example 1:
Input:

project_id	employee_id
1	1
1	2
1	3
2	1
2	4

Project table:

employee_id	name	experience_years
1	Khaled	3
2	Ali	2
3	John	1
4	Doe	4

Employee table:

Output:

project_id

Explanation: The first project has 3 employees while the second one has 2.

Project Employees II LeetCode Solution MySQL

select 
  project_id 
from 
  Project 
group by 
  project_id 
having 
  count(employee_id) >= (
    select 
      count(employee_id) as cnt 
    from 
      Project 
    group by 
      project_id 
    order by 
      cnt desc 
    limit 
      1
  );Code language: SQL (Structured Query Language) (sql)

Project Employees II LeetCode Solution

Table of Contents

Project Employees II LeetCode Solution MySQL

Related Posts