I'm having a little fun and I'd love to know how to write a SQL or dwSQL query across these two datasets of Trumps tweets and Facebook posts. Here are the datasets:
Trump Facebook Posts https://data.world/dave/trumps-facebook-statuses
Trump Tweets https://data.world/dave/trump-tweets
Ideally I would like to be able to count the distinct instances that a word or phrase (like 'crooked' or 'massive' or 'the best' appeared across both datasets.
The table name for the Facebook Post dataset is
TrumpFacebook and for the Trump Tweets is