Ads Performance — LeetCode 1322 Python Solution
EasyLeetCode PremiumDatabase
- Problem
- #1322
- Reading time
- 2 min
- Source
- leetcode.com
Table schema
SQL
Table: Ads +---------------+---------+ | Column Name | Type | +---------------+---------+ | ad_id | int | | user_id | int | | action | enum | +---------------+---------+ (ad_id, user_id) is the primary key (combination of columns with unique values) for this table. Each row of this table contains the ID of an Ad, the ID of a user, and the action taken by this user regarding this Ad.Example
SQL
+---------------+---------+
| Column Name | Type |
+---------------+---------+
| ad_id | int |
| user_id | int |
| action | enum |
+---------------+---------+
(ad_id, user_id) is the primary key (combination of columns with unique values) for this table.
Each row of this table contains the ID of an Ad, the ID of a user, and the action taken by this user regarding this Ad.
The action column is an ENUM (category) type of ('Clicked', 'Viewed', 'Ignored').Complexity
| Measure | Complexity |
|---|---|
| Time | O(n log n) (typical) |
| Space | O(n) auxiliary |
Related problems
Frequently asked questions
- How hard is LeetCode 1322. Ads Performance?
- LeetCode 1322. Ads Performance is rated Easy on LeetCode.
- What topics does LeetCode 1322. Ads Performance cover?
- LeetCode 1322. Ads Performance is tagged Database on LeetCode.
- Is LeetCode 1322. Ads Performance a premium problem?
- Yes. LeetCode 1322. Ads Performance is a LeetCode Premium problem, so the full statement and test cases require a paid LeetCode subscription.