Loading problem...
A trust-and-safety analytics team runs a daily compliance audit on short social posts.
Table: posts
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:
Supported submission environments:
posts:
| post_id | body |
|---------|------------------------------|
| 1 | Daily sync |
| 2 | this message is too long |
| 3 | ready now |[
{"post_id":2}
]Post 2 has more than 15 characters. Posts 1 and 3 are within the limit.
posts:
| post_id | body |
|---------|-------------------|
| 10 | abcdefghijklmno |
| 11 | abcdefghijklmnop |
| 12 | ok |[
{"post_id":11}
]Length 15 is valid, while length 16 is violating.
posts:
| post_id | body |
|---------|---------------------|
| 21 | many spaces here ! |
| 22 | short msg |
| 23 | exactly15char!! |[
{"post_id":21}
]Whitespace and punctuation are counted as characters. Row 21 exceeds 15, while 23 is exactly 15.
Constraints