Pulling social media data into a SQL database -- 2

This piece of week needs to be integrated with the existing code we have for this project. This needs to be delivered to us by Friday 6th October AM BST time. I have the code and will share it once you have been shortlisted. A solution that downloads all relevant data, for all Organisations, Celebrities and Social Media Entities from the publicly available APIs across this clients key Social Media channels into a SQL database • All code to be written in C# • Database to be SQL 2016 We need to pull a number of elements from Twitter- Hashtags, i.e. those that don't have a handle. This is what we need to pull: TWITTER – HASHTAGS (FOR PEOPLE WHO DON’T HAVE A HANDLE) T1. Number of tweets for given hashtag: this needs to simply query the twitter API based on a single hashtag e.g. #barackobama. There needs to be the ability for the client to enter a hashtag of their choice, and it makes a query and delivers a result T2. Engagement on hashtag- this needs to the total number of times the hashtag has been engaged with - for example how many times the hashtag has been clicked on OR whatever is possible with the API, but something similar. T3. Number of tweets tagged with said hashtag over a period of time (configurable)-the same as point T1 but configurable, so I want to see how many time #barackobama has been used over say 3 months T4. Number of likes on above tweets linked to hashtag- so the tweet the hashtag has been included in, the number of time it has been liked. T5. Number of retweets on above tweets linked to hashtag- same as T4 but the number of times the tweet, that has the hashtag, has been retweeted