Activity Participants — LeetCode 1355 Python Solution

Table: Friends +---------------+---------+ | Column Name | Type | +---------------+---------+ | id | int | | name | varchar | | activity | varchar | +---------------+---------+ id is the id of the friend and the primary key for this table in SQL. name is the name of the friend.

+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| id            | int     |
| name          | varchar |
| activity      | varchar |
+---------------+---------+
id is the id of the friend and the primary key for this table in SQL.
name is the name of the friend.
activity is the name of the activity which the friend takes part in.

import duckdb
import pandas as pd

def solution(friends: pd.DataFrame, activities: pd.DataFrame) -> pd.DataFrame:
    con = duckdb.connect()
    con.register("Friends", friends)
    con.register("Activities", activities)
    return con.execute("""WITH
    t AS (
        SELECT activity, COUNT(1) AS cnt
        FROM Friends
        GROUP BY activity
    )
SELECT activity
FROM t
WHERE cnt > (SELECT MIN(cnt) FROM t) AND cnt < (SELECT MAX(cnt) FROM t);""").df()