use copbird;
SELECT count(tweet.id) as "tweet_count", `user`.handle 
FROM tweet
JOIN `user` on tweet.user_id = `user`.id
GROUP BY `user`.name ;