A midterm test on basic SQL for my journalism class

In plain words

This is a SQL midterm exam designed for journalism students learning data analysis and programming. It tests knowledge of SQL fundamentals through practical exercises using a Congressional Twitter dataset. The assessment covers core concepts including LEFT joins and many-to-one relationships, with provided example queries and dataset documentation to guide students through independent problem-solving.

written from the facts on this page · September 2026

From the sources

A casual midterm covering the range of data analysis and programming skills acquired so far. The notes for this section consist entirely of the description for the dataset used for the midterm, example queries to help you understand the dataset, and then a few questions for you to tackle on your own. Everything covered here has been covered in the tutorials , though you'll probably want to make sure you have a good understanding of LEFT joins and many-to-one-relationships . Regarding the time-series (or histogram ) chart, by political party, of Congressmembers and the number of Tweets mentioning "ebola" as of October 20, 2014. The result is 811 tweets, which I've uploaded to this Google…from padjo.org

• 
  I made a SQL game to help people learn / challenge their skills2023 · lost-at-sql.therobinlord.com · ▲547

  The text-based SQL learning game for data scientists and marketers

• 
  Natural-SQL-7B, a strong text-to-SQL model2024 · github.com · ▲362

  Would love thoughts! Here is the HF page: https://huggingface.co/chatdb/natural-sql-7b

• ST
  SQL Trainer – Learn SQL by doing live data exercises2018 · app.bytescout.com · ▲303
• 
  SQL Teaching – Codecademy for SQL2015 · sqlteaching.com · ▲166

  The easiest way to learn SQL

• 
  SQL FOR ZOMBIES2015 · alexpineda.gumroad.com · ▲75

  Entertaining way to learn SQL

• 
  SQL School2014 · sqlschool.modeanalytics.com · ▲144

  Data analysts training data analysts

• 
  /dev/null▲490

  a social network for devs

  Dev tools · 3d ago · dev-null.sh

• 
  Whiteboard (YC W26) – an open-source IDE for thoughtful software design▲423

  open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.

  Dev tools · 28d ago · github.com

• 
  Reladraw – A diagram language where you decide where to place things▲411

  Contribute to reladraw/reladraw development by creating an account on GitHub.

  Dev tools · 26d ago · github.com

• 
  OpenBot▲362

  Grok Bot alternative: free, local, open-source, multiplayer

  Dev tools · 23d ago · openbot.run

• 
  Talanoa▲346

  Hi HN, I’m a fullstack developer, and honestly, I’ve lost count of how many side projects I’ve worked on over the years. But one idea kept coming back to me: a different kind of email client. It first came to me in 2014: “What if we could handle emails more like conversations?” Every year, I’d revisit this concept in my “Build Notes.” Ten years later, no one had built exactly what I had in mind — so I finally decided to do it myself. That’s how Talanoa was born. I wanted something focused on people, not timelines. I was tired of marking messages as unread just to remember to reply later, or…

  Dev tools · 21d ago · talanoa.email

• 
  CoreSpeed▲332

  One MCP for everything your agents need: apps, memory, tools

  Dev tools · 29d ago · corespeed.io

• 
  Coolors▲1,589

  Super fast color schemes generator for cool designers

  Work · 2014 · coolors.co

• 
  Inbox by Google▲1,147

  Next generation inbox

  Life & fun · 2014 · google.com

• 
  Stock Up▲641

  The best free stock photos in one place

  Life & fun · 2014 · stockup.sitebuilderreport.com

• 
  Writefull▲511

  A tiny tool to help you write better

  Work · 2014 · writefull.com

• 
  Mattermark▲511

  Ranking 800,000+ high growth Internet companies

  Growth · 2014 · mattermark.com

• 
  Petit Hacks▲506

  Acquisition, retention, & revenue hacks used by companies

  Life & fun · 2014