How hard is LeetCode 2989. Class Performance?

LeetCode 2989. Class Performance is rated Medium on LeetCode.

What topics does LeetCode 2989. Class Performance cover?

LeetCode 2989. Class Performance is tagged Database on LeetCode.

Is LeetCode 2989. Class Performance a premium problem?

Yes. LeetCode 2989. Class Performance is a LeetCode Premium problem, so the full statement and test cases require a paid LeetCode subscription.

Class Performance — LeetCode 2989 Python Solution

MediumLeetCode PremiumDatabase

Problem: #2989
Reading time: 2 min
Source: leetcode.com

Table schema

SQL

Table: Scores +--------------+---------+ | Column Name | Type | +--------------+---------+ | student_id | int | | student_name | varchar | | assignment1 | int | | assignment2 | int | | assignment3 | int | +--------------+---------+ student_id is column of unique values for this table. This table contains student_id, student_name, assignment1, assignment2, and assignment3.

Example

SQL

+--------------+---------+
| Column Name  | Type    |
+--------------+---------+
| student_id   | int     |
| student_name | varchar |
| assignment1  | int     |
| assignment2  | int     |
| assignment3  | int     |
+--------------+---------+
student_id is column of unique values for this table.
This table contains student_id, student_name, assignment1, assignment2, and assignment3.

Python solution

Python

import duckdb
import pandas as pd

def solution(scores: pd.DataFrame) -> pd.DataFrame:
    con = duckdb.connect()
    con.register("Scores", scores)
    return con.execute("""SELECT
    MAX(assignment1 + assignment2 + assignment3) - MIN(
        assignment1 + assignment2 + assignment3
    ) AS difference_in_score
FROM Scores;""").df()

Complexity

Measure	Complexity
Time	O(n log n) (typical)
Space	O(n) auxiliary

Frequently asked questions

How hard is LeetCode 2989. Class Performance?: LeetCode 2989. Class Performance is rated Medium on LeetCode.
What topics does LeetCode 2989. Class Performance cover?: LeetCode 2989. Class Performance is tagged Database on LeetCode.
Is LeetCode 2989. Class Performance a premium problem?: Yes. LeetCode 2989. Class Performance is a LeetCode Premium problem, so the full statement and test cases require a paid LeetCode subscription.