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
SELECT friend_user_id FROM friends_count WHERE friends_user_id='friends_user_id'
Hey Neal, it doesn't look like you've fully completed this challenge. You're missing part 4) Reflect.
Also, could you please format the SQL queries so that it is clearer which query is answering which question? You can even format your SQL to look all pretty using syntax highlighting in GitHub Flavored Markdown.
Please make the necessary changes and re-submit.