Invalid Tweets
Twitter
Problem Statement
A platform policy requires monitoring tweets that exceed a specific character limit for certain UI components.
Write an SQL query to find the IDs of the invalid tweets. A tweet is considered invalid if the number of characters used in the content of the tweet is strictly greater than 15.
Rules:
- Return the result table containing only the tweet_id column.
- The content length should be calculated based on the number of characters, not bytes.
- The order of the output does not matter.
Tests your understanding of
Basic SQL, Filtering, String Functions and LENGTH
Input Tables
tweets
| tweet_id(INTEGER) | content(VARCHAR) |
|---|---|
| 1 | Vote for me |
| 2 | Let us make the world a better place |
| 3 | SQL is fun! |
| 4 | Follow for more updates! |
| 5 | Hello World |
| 6 | This tweet is exactly 15 chars |
Expected Output
| tweet_id(INTEGER) |
|---|
| 2 |
| 4 |
| 6 |
Tags
EasyBasic SQLFilteringString FunctionsLENGTH
5-10 min
82%