Social Feed Compliance Screening

EASY10 pts

A trust-and-safety pipeline scans social posts to flag records that violate publishing limits.

Table: Tweets

tweet_id: unique post identifier
content: raw post text

A post is considered invalid if it violates at least one rule:

content length is strictly greater than 140 characters
content contains more than 3 '@' characters
content contains more than 3 '#' characters

Task: Return all invalid post IDs.

Output requirements:

Return exactly one column in this order: tweet_id
Sort output by tweet_id in ascending order.

Supported submission environments:

SQL (SQLite 3.27.2)
Pandas (Python)

Example

Input

Tweets:
| tweet_id | content                                                          |
|----------|------------------------------------------------------------------|
| 1        | launching now @ops @infra @qa @support                           |
| 2        | daily digest #news #product #release #mobile                     |
| 3        | rollout complete @ops #stable                                    |

Output

[
  {"tweet_id": 1},
  {"tweet_id": 2}
]

Explanation

Tweet 1 has 4 mentions and tweet 2 has 4 hashtags. Tweet 3 satisfies all limits.

Example

Input

Tweets:
| tweet_id | content                                                         |
|----------|-----------------------------------------------------------------|
| 10       | short update @a @b #x                                           |
| 11       | exactly three mentions @a @b @c and three tags #a #b #c        |
| 12       | status ok                                                       |

Output

[]

Explanation

All tweets remain within the 140-character, mention, and hashtag limits.

Example

Input

Tweets:
| tweet_id | content                                                                 |
|----------|-------------------------------------------------------------------------|
| 21       | xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx |
| 22       | spike @u1 @u2 @u3 @u4 #urgent #audit #ops #incident                     |
| 23       | brief post #ok                                                          |

Output

[
  {"tweet_id": 21},
  {"tweet_id": 22}
]

Explanation

Tweet 21 exceeds the character limit. Tweet 22 violates both mention and hashtag limits.

Accepted0/0·0% Acceptance

Constraints

1 <= number of rows in Tweets <= 200000
1 <= tweet_id <= 2000000000
tweet_id is unique per test case
1 <= content length <= 300
A tweet is invalid if any one of the three policy checks fails
Character counting uses full string length in SQLite and Pandas
Mention counting is based on occurrences of '@'
Hashtag counting is based on occurrences of '#'
Return exactly one column: tweet_id
Sort final output by tweet_id ASC
SQL submissions run on SQLite 3.27.2
Pandas submissions must return a DataFrame with column [tweet_id]

Code

Visualizer

Solutions

14px

Test Cases3

Results

Submissions

Tweets =

[{"tweet_id":1,"content":"launch@alpha@beta@gamma@delta"},{"tweet_id":2,"content":"trend#one#two#three#four"},{"tweet_id":3,"content":"status update #ok"}]

Social Feed Compliance Screening

Hints

Social Feed Compliance Screening

Hints