EasyNo. 2072LeetCode Premium
The Winner University — LeetCode 2072 Python Solution
- Topics
- Database
- Reading time
- 3 min
- Source
- leetcode.com
Table schema
Table: NewYork +-------------+------+ | Column Name | Type | +-------------+------+ | student_id | int | | score | int | +-------------+------+ In SQL, student_id is the primary key for this table. Each row contains information about the score of one student from New York University in an exam.Example
+-------------+------+
| Column Name | Type |
+-------------+------+
| student_id | int |
| score | int |
+-------------+------+
In SQL, student_id is the primary key for this table.
Each row contains information about the score of one student from New York University in an exam.Python solution
import duckdb
import pandas as pd
def solution(new_york: pd.DataFrame, california: pd.DataFrame) -> pd.DataFrame:
con = duckdb.connect()
con.register("NewYork", new_york)
con.register("California", california)
return con.execute("""SELECT
CASE
WHEN n1.cnt > n2.cnt THEN 'New York University'
WHEN n1.cnt < n2.cnt THEN 'California University'
ELSE 'No Winner'
END AS winner
FROM
(SELECT COUNT(1) AS cnt FROM NewYork WHERE score >= 90) AS n1,
(SELECT COUNT(1) AS cnt FROM California WHERE score >= 90) AS n2;""").df()Complexity
- Time
- O(n log n)(typical)
- Space · auxiliary
- O(n)
Related problems
| No. | Problem | Difficulty |
|---|---|---|
| 0175 | Combine Two Tables | Easy |
| 0176 | Second Highest Salary | Medium |
| 0177 | Nth Highest Salary | Medium |
| 0178 | Rank Scores | Medium |
| 0180 | Consecutive Numbers | Medium |
| 0181 | Employees Earning More Than Their Managers | Easy |
Frequently asked questions
- How hard is LeetCode 2072. The Winner University?
LeetCode 2072. The Winner University is rated Easy on LeetCode.
- What topics does LeetCode 2072. The Winner University cover?
LeetCode 2072. The Winner University is tagged Database on LeetCode.
- Is LeetCode 2072. The Winner University a premium problem?
Yes. LeetCode 2072. The Winner University is a LeetCode Premium problem, so the full statement and test cases require a paid LeetCode subscription.