Conversation

Well hello there possible Twitter bots ... SELECT screen_name, percentile_disc(0.5) within group (ORDER BY tweet_id_to_timestamp(id) - tweet_id_to_timestamp(retweeted_id)) "Median Retweet Delay", count(*) from retweet GROUP BY screen_name HAVING count(*) > 10 ORDER BY 2 ASC;
Image
2
23