|< < 27 > >|

Queries

Query (pseudo-code)

One possible query (implemented as procedural pseudo-code):
tweets = {} // map from date to int // Clear count for each date for each date between '2016/03/01' and today: tweets[date] = 0 // How many accounts started on 3/1/16? Record tweets by date for each. accounts = 0 for each account in allAccounts: if account.created == '2016/03/01': accounts += 1 for each tweet in account.tweets: tweets[date(tweet.timestamp)] += 1 // Print results, sorted by date for each date between '2016/03/01' and today: averageTweets = tweets[date] / accounts print date, averageTweets

|< < 27 > >|