tag

#window-function

12 pages tagged

Practice › LeetCode › LeetCode (archived) › LeetCode 06xx ›

LeetCode 615: Average Salary: Departments VS Company

Problem Restatement We are given two tables: Salary and Employee . The Salary table stores each employee's salary for a month. Column Type Meaning id int Salary record id employee_id int Employee id amount int Salary amount pay_date date Salary payment date The Employee table stores each employee's department. Column Type Meaning employee_id int Employee id department_id int Department id We need to compare each department's average salary with the...
leetcode sql window-function group-by database May 12, 2026
Practice › LeetCode › LeetCode (archived) › LeetCode 06xx ›

LeetCode 613: Shortest Distance in a Line

Problem Restatement We are given a table called Point . Each row stores one point on the X-axis. Column Type Meaning x int Position of the point on the X-axis The column x is the primary key, so every point is unique. We need to find the shortest distance between any two points. The official problem asks for the minimum distance between any two points from the Point table. Input...
leetcode sql self-join window-function database May 12, 2026
Practice › LeetCode › LeetCode (archived) › LeetCode 05xx ›

LeetCode 571: Find Median Given Frequency of Numbers

Problem Restatement We are given a Numbers table. Column Type Meaning num int The number value frequency int How many times this number appears Each row stores a number and its frequency. Conceptually, the table represents a decompressed list of numbers. For example, if num = 0 and frequency = 7 , then 0 appears seven times in the full list. We need to report the median of all numbers...
leetcode sql database window-function prefix-sum May 11, 2026
Practice › LeetCode › LeetCode (archived) › LeetCode 05xx ›

LeetCode 569: Median Employee Salary

Problem Restatement We are given an Employee table. Column Type Meaning id int Employee id company varchar Company name salary int Employee salary We need to return the rows that contain the median salary of each company. When sorting salaries inside a company, ties are broken by id . If a company has an odd number of employees, return the one middle row. If a company has an even number...
leetcode sql database window-function May 11, 2026
Practice › LeetCode › LeetCode (archived) › LeetCode 06xx ›

LeetCode 603: Consecutive Available Seats

Problem Restatement We are given a table called Cinema . Each row tells us whether a seat is free or occupied. Column Type Meaning seat_id int Seat id free bool 1 means free, 0 means occupied We need to return all free seats that are part of at least one consecutive pair of free seats. The result should be ordered by seat_id . The problem note says seat_id is auto-incremented,...
leetcode sql self-join window-function database May 11, 2026
Practice › LeetCode › LeetCode (archived) › LeetCode 06xx ›

LeetCode 601: Human Traffic of Stadium

Problem Restatement We are given a table called Stadium . Each row records one stadium visit day. The table has three columns: Column Type Meaning id int Visit id visit_date date Date of the visit people int Number of people who visited We need to return all rows that are part of a group of at least three consecutive id values where every row has people >= 100 . The...
leetcode sql window-function grouping database May 11, 2026
Practice › LeetCode › LeetCode (archived) › LeetCode 05xx ›

LeetCode 534: Game Play Analysis III

Problem Restatement We are given a table named Activity . Each row records one player's activity on one date. It contains the player id, device id, event date, and number of games played. We need to report, for each player and each date, the total number of games the player has played so far up to that date. The output should contain: player_id event_date games_played_so_far The result may be returned...
leetcode sql database window-function aggregation May 11, 2026
Practice › LeetCode › LeetCode (archived) › LeetCode 05xx ›

LeetCode 579: Find Cumulative Salary of an Employee

Problem Restatement We are given an Employee table that stores each employee's salary for different months. For each employee and each month they worked, we need to calculate the sum of that month's salary and the salaries from the previous two months. However, we must not include the employee's most recent month in the output. The result should be ordered by id in ascending order, then by month in descending...
leetcode sql window-function self-join aggregation May 11, 2026
Practice › LeetCode › LeetCode (archived) › LeetCode 01xx ›

LeetCode 185: Department Top Three Salaries

Problem Restatement We are given two tables: Employee and Department . Employee stores employee information. Column Type id int name varchar salary int departmentId int Department stores department information. Column Type id int name varchar Each employee belongs to a department through Employee.departmentId . We need to find employees who are high earners in their department. A high earner is an employee whose salary is in the top three unique...
leetcode sql database window-function dense-rank May 10, 2026
Practice › LeetCode › LeetCode (archived) › LeetCode 01xx ›

LeetCode 184: Department Highest Salary

Problem Restatement We are given two tables: Employee and Department . Employee stores employee information. Column Type id int name varchar salary int departmentId int Department stores department information. Column Type id int name varchar Each employee belongs to one department through Employee.departmentId . We need to find employees who have the highest salary in each department. If multiple employees share the highest salary in the same department, we return...
leetcode sql database join group-by window-function May 10, 2026
Practice › LeetCode › LeetCode (archived) › LeetCode 01xx ›

LeetCode 180: Consecutive Numbers

Problem Restatement We are given a table named Logs . Column Type id int num varchar The column id is the primary key. It is an auto-increment column starting from 1 . We need to find every number that appears at least three times consecutively. The result can be returned in any order. The output column should be named ConsecutiveNums . The official statement asks for all numbers that appear...
leetcode sql database self-join window-function May 10, 2026
Practice › LeetCode › LeetCode (archived) › LeetCode 01xx ›

LeetCode 178: Rank Scores

Problem Restatement We are given a table named Scores . Column Type id int score decimal Each row stores the score of a game. We need to rank all scores from highest to lowest. The ranking rules are: Rule Meaning Higher score gets smaller rank The highest score has rank 1 Equal scores share the same rank Two 4.00 scores both get rank 1 No rank gaps After rank 1...
leetcode sql database window-function dense-rank May 10, 2026