Solution for Challenge: SOLO CHALLENGE: Modeling a One to Many Database. Started 2014-02-08T19:19:41+00:00
SELECT tweet FROM tweets WHERE user_id='user_id'
SELECT tweet FROM tweets WHERE user_id='user_id' AND creation_at >= '2014-01-05'
SELECT tweet FROM tweets JOIN user ON user.user_id=tweet.user_id WHERE user_name='user_name'
SELECT user_name FROM user JOIN tweet ON user.user_id=tweet.user_id WHERE tweet_id='tweet_id'
SELECT COUNT(friends_count) FROM user