SQL Join Practice with Twitter and Tweets¶
This is just practice, using data/examples from a prior lesson. Read it over, see if you can write thq queries for the exercises (the prompts are copied on this page below) without looking at the answers:
Download the SQLite dump of Congress and Twitter data
See if you can answer these questions (without looking at the answers):
- Which Congressmember has the most followers?
- Which Congressmember has been on Twitter the longest?
- What are the top 5 Texas Congressmembers by tweet count?
- Which party has the most followers combined?
- List the state and party averages of number of followers per Congressmember