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