Skip to content

3150. Invalid Tweets II

1
2
3
4
5
6
7
SELECT tweet_id
FROM Tweets
WHERE
  LENGTH(content) > 140
  OR LENGTH(content) - LENGTH(REPLACE(content, '@', '')) > 3
  OR LENGTH(content) - LENGTH(REPLACE(content, '#', '')) > 3
ORDER BY 1;