Leetcode Problem 1355. Activity Participants

1355. Activity Participants

Leetcode Solutions

Using RANK() to Identify Non-Extreme Activities

Use a SELECT statement to count the number of participants for each activity from the Friends table and group by activity.
Apply the RANK() window function over the count in ascending order to get the rank_asc for each activity.
Apply the RANK() window function over the count in descending order to get the rank_desc for each activity.
Use a subquery or common table expression (CTE) to select activities where both rank_asc and rank_desc are not equal to 1.
Return the activity names that meet the above condition.

erDiagram
    Friends ||--o{ Activities : has
    Friends {
        int id PK
        varchar name
        varchar activity
    }
    Activities {
        int id PK
        varchar name
    }

Using NOT IN with Aggregated Subqueries

Ask Question

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen

Leetcode Problem 1355. Activity Participants

Leetcode Solutions

Using RANK() to Identify Non-Extreme Activities

Solution Idea

Query Steps

Code Implementation

Using NOT IN with Aggregated Subqueries

Ask Question

Suggested Answer