Message Length Policy Violations

Easy

A trust-and-safety analytics team runs a daily compliance audit on short social posts. Table: posts post_id: unique identifier for each post body: post text submitted by users Policy rule: A post is marked as violating when the character count of body is strictly greater than 15. Task: Return the IDs of all violating posts. Output requirements: Return exactly one column named post_id. Sort output by post_id in ascending order. Supported submission environments: SQL (SQLite 3.27.2) Pandas (Python)

Example 1

Input

posts:
| post_id | body                         |
|---------|------------------------------|
| 1       | Daily sync                   |
| 2       | this message is too long     |
| 3       | ready now                    |

Output

[
  {"post_id":2}
]

Explanation

Post 2 has more than 15 characters. Posts 1 and 3 are within the limit.

Example 2

Input

posts:
| post_id | body              |
|---------|-------------------|
| 10      | abcdefghijklmno   |
| 11      | abcdefghijklmnop  |
| 12      | ok                |

Output

[
  {"post_id":11}
]

Explanation

Length 15 is valid, while length 16 is violating.

Example 3

Input

posts:
| post_id | body                |
|---------|---------------------|
| 21      | many spaces here !  |
| 22      | short msg           |
| 23      | exactly15char!!     |

Output

[
  {"post_id":21}
]

Explanation

Whitespace and punctuation are counted as characters. Row 21 exceeds 15, while 23 is exactly 15.

Constraints

1 <= number of rows in posts <= 200000
1 <= post_id <= 2147483647
post_id values are unique
0 <= length(body) <= 280
body may include letters, digits, spaces, and punctuation
Use character count semantics for length checks
Return exactly one column named post_id
Sort output by post_id ascending
Use SQLite 3.27.2 behavior for SQL submissions
For Pandas submissions, return a DataFrame with column post_id

Loading problem...