Queries
For all Twitter accounts created on March 1 2016,
what is the total number of tweets per day,
ordered by day?
Expressing the query in SQL
select date(tweet.timestamp), count(*)
from account, tweet
where tweet.author = account.id
and account.created = date('2016-03-01')
group by date(tweet.timestamp)
order by date(tweet.timestamp)
|