100 % FAST && EASY SQL Query || Well - Explained || Beats 99.9 %
Intuition\n Describe your first thoughts on how to solve this problem. \nSELECT --> for show the table...\nDISTINCT tweet_id --> consider tweet ids...\nFROM -->
# Intuition\n<!-- Describe your first thoughts on how to solve this problem. -->\nSELECT --> for show the table...\nDISTINCT tweet_id --> consider tweet ids...\nFROM --> for association...\nTweets --> Table name...\nWHERE --> Clause...\nLENGTH(content) > 15 --> Condition given in problem...\nLENGTH is a function to find length...\n\n# Approach\n<!-- Describe your approach to solving the problem. -->\nUsing Fundamentals of SQL...\n\n# Complexity\n- Time complexity: O(n)\n<!-- Add your time complexity here, e.g. $$O(n)$$ -->\n\n- Space complexity: O(1)\n<!-- Add your space complexity here, e.g. $$O(n)$$ -->\n\n# Code\n```\nSELECT DISTINCT tweet_id FROM Tweets\nWHERE LENGTH(content) > 15;\n```
['Database', 'MySQL']