How hard is LeetCode 1126. Active Businesses?

LeetCode 1126. Active Businesses is rated Medium on LeetCode.

What topics does LeetCode 1126. Active Businesses cover?

LeetCode 1126. Active Businesses is tagged Database on LeetCode.

Is LeetCode 1126. Active Businesses a premium problem?

Yes. LeetCode 1126. Active Businesses is a LeetCode Premium problem, so the full statement and test cases require a paid LeetCode subscription.

Active Businesses — LeetCode 1126 Python Solution

MediumLeetCode PremiumDatabase

Problem: #1126
Reading time: 4 min
Source: leetcode.com

Table schema

SQL

Table: Events +---------------+---------+ | Column Name | Type | +---------------+---------+ | business_id | int | | event_type | varchar | | occurrences | int | +---------------+---------+ (business_id, event_type) is the primary key (combination of columns with unique values) of this table. Each row in the table logs the info that an event of some type occurred at some business for a number of times.

Example

SQL

+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| business_id   | int     |
| event_type    | varchar |
| occurrences   | int     | 
+---------------+---------+
(business_id, event_type) is the primary key (combination of columns with unique values) of this table.
Each row in the table logs the info that an event of some type occurred at some business for a number of times.

Python solution

Python

import duckdb
import pandas as pd

def solution(events: pd.DataFrame) -> pd.DataFrame:
    con = duckdb.connect()
    con.register("Events", events)
    return con.execute("""SELECT business_id
FROM
    EVENTS AS t1
    JOIN (
        SELECT
            event_type,
            AVG(occurences) AS occurences
        FROM EVENTS
        GROUP BY event_type
    ) AS t2
        ON t1.event_type = t2.event_type
WHERE t1.occurences > t2.occurences
GROUP BY business_id
HAVING COUNT(1) > 1;""").df()

Complexity

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

Frequently asked questions

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