How many tweets are on the topic intern
select count ( * ) from tweets where text like '%intern%'
which tweet has the newest creation date?
select * from tweets order by createdate desc limit 1
what about the oldest tweet?
select * from tweets order by createdate limit 1