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:

Basic SQL Inner joins

Download the SQLite dump of Congress and Twitter data

See if you can answer these questions (without looking at the answers):

Exercises

1. Which Congressmember has the most followers?
2. Which Congressmember has been on Twitter the longest?
3. What are the top 5 Texas Congressmembers by tweet count?
4. Which party has the most followers combined?
5. List the state and party averages of number of followers per Congressmember