SQL 2: Grouping and summing data

  • Event: 2019 CAR Conference
  • Speaker: Matt Kiefer of Stanford University
  • Date/Time: Thursday, Mar. 7 at 10:15am
  • Location: Salon 4
  • Audio file: No audio file available.

If you know how to write a basic SELECT statement in SQL but are looking to make calculations, then this is the session for you. Learn to count how many times certain records appear in a database, and sum totals across records. These skills can come in handy whether you're covering campaign finance or boating licenses. We'll use SQLite and DB Browser, a free database manager.

This session is good for: People who took “SQL 1: Exploring data” or are familiar with “SELECT” and “WHERE” statements in SQL.

Speaker Bios

  • Matt Kiefer is a John S. Knight Journalism Fellow at Stanford University, researching and prototyping automation tools to monitor civil and human rights. He's on leave from his job as data editor at the Chicago Reporter, a non-profit newsroom that investigates inequality. @matt_kiefer

Related Tipsheets

No tipsheets have yet been uploaded for this event.