mirror of
https://gitee.com/coder-xiaomo/leetcode-problemset
synced 2025-01-10 18:48:13 +08:00
45 lines
1.4 KiB
HTML
45 lines
1.4 KiB
HTML
<p>Table: <code>Tweets</code></p>
|
|
|
|
<pre>
|
|
+----------------+---------+
|
|
| Column Name | Type |
|
|
+----------------+---------+
|
|
| tweet_id | int |
|
|
| content | varchar |
|
|
+----------------+---------+
|
|
tweet_id is the primary key (column with unique values) for this table.
|
|
content consists of characters on an American Keyboard, and no other special characters.
|
|
This table contains all the tweets in a social media app.
|
|
</pre>
|
|
|
|
<p> </p>
|
|
|
|
<p>Write a solution to find the IDs of the invalid tweets. The tweet is invalid if the number of characters used in the content of the tweet is <strong>strictly greater</strong> than <code>15</code>.</p>
|
|
|
|
<p>Return the result table in <strong>any order</strong>.</p>
|
|
|
|
<p>The result format is in the following example.</p>
|
|
|
|
<p> </p>
|
|
<p><strong class="example">Example 1:</strong></p>
|
|
|
|
<pre>
|
|
<strong>Input:</strong>
|
|
Tweets table:
|
|
+----------+-----------------------------------+
|
|
| tweet_id | content |
|
|
+----------+-----------------------------------+
|
|
| 1 | Let us Code |
|
|
| 2 | More than fifteen chars are here! |
|
|
+----------+-----------------------------------+
|
|
<strong>Output:</strong>
|
|
+----------+
|
|
| tweet_id |
|
|
+----------+
|
|
| 2 |
|
|
+----------+
|
|
<strong>Explanation:</strong>
|
|
Tweet 1 has length = 11. It is a valid tweet.
|
|
Tweet 2 has length = 33. It is an invalid tweet.
|
|
</pre>
|