EasyNo. 1076LeetCode Premium
Project Employees II — LeetCode 1076 Python Solution
- Topics
- Database
- Reading time
- 3 min
- Source
- leetcode.com
Table schema
Table: Project +-------------+---------+ | Column Name | Type | +-------------+---------+ | project_id | int | | employee_id | int | +-------------+---------+ (project_id, employee_id) is the primary key (combination of columns with unique values) of this table. employee_id is a foreign key (reference column) to Employee table.Example
+-------------+---------+
| Column Name | Type |
+-------------+---------+
| project_id | int |
| employee_id | int |
+-------------+---------+
(project_id, employee_id) is the primary key (combination of columns with unique values) of this table.
employee_id is a foreign key (reference column) to Employee table.
Each row of this table indicates that the employee with employee_id is working on the project with project_id.Python solution
import duckdb
import pandas as pd
def solution(project: pd.DataFrame, employee: pd.DataFrame) -> pd.DataFrame:
con = duckdb.connect()
con.register("Project", project)
con.register("Employee", employee)
return con.execute("""SELECT project_id
FROM Project
GROUP BY 1
HAVING
COUNT(1) >= all(
SELECT COUNT(1)
FROM Project
GROUP BY project_id
);""").df()Complexity
- Time
- O(n log n)(typical)
- Space · auxiliary
- O(n)
Related problems
| No. | Problem | Difficulty |
|---|---|---|
| 1068 | Product Sales Analysis I | Easy |
| 0175 | Combine Two Tables | Easy |
| 0176 | Second Highest Salary | Medium |
| 0177 | Nth Highest Salary | Medium |
| 0178 | Rank Scores | Medium |
| 0180 | Consecutive Numbers | Medium |
Frequently asked questions
- How hard is LeetCode 1076. Project Employees II?
LeetCode 1076. Project Employees II is rated Easy on LeetCode.
- What topics does LeetCode 1076. Project Employees II cover?
LeetCode 1076. Project Employees II is tagged Database on LeetCode.
- Is LeetCode 1076. Project Employees II a premium problem?
Yes. LeetCode 1076. Project Employees II is a LeetCode Premium problem, so the full statement and test cases require a paid LeetCode subscription.