Skip to content

Instantly share code, notes, and snippets.

@morsapaes

morsapaes/hex_twitter_not_there.sql

Created April 25, 2022 14:02
Show Gist options
  • Save morsapaes/9face1a9b21a9fb798f1876bbfc4915a to your computer and use it in GitHub Desktop.
Save morsapaes/9face1a9b21a9fb798f1876bbfc4915a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
hex_twitter_not_there.sql
SELECT *
FROM twitter_tweets_enriched
WHERE username IN (SELECT username FROM users_not_there)
ORDER BY created_at DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment