Users That Actively Request Confirmation Messages — LeetCode 1939 Python Solution

Table: Signups +----------------+----------+ | Column Name | Type | +----------------+----------+ | user_id | int | | time_stamp | datetime | +----------------+----------+ user_id is the column with unique values for this table. Each row contains information about the signup time for the user with ID user_id.

+----------------+----------+
| Column Name    | Type     |
+----------------+----------+
| user_id        | int      |
| time_stamp     | datetime |
+----------------+----------+
user_id is the column with unique values for this table.
Each row contains information about the signup time for the user with ID user_id.

import duckdb
import pandas as pd

def solution(signups: pd.DataFrame, confirmations: pd.DataFrame) -> pd.DataFrame:
    con = duckdb.connect()
    con.register("Signups", signups)
    con.register("Confirmations", confirmations)
    return con.execute("""SELECT DISTINCT user_id
FROM
    Confirmations AS c1
    JOIN Confirmations AS c2 USING (user_id)
WHERE
    c1.time_stamp < c2.time_stamp
    AND TIMESTAMPDIFF(SECOND, c1.time_stamp, c2.time_stamp) <= 24 * 60 * 60;""").df()