Counting & summing with SQL

  • Event: 2016 CAR Conference
  • Speaker: Meghan Hoyer of The Associated Press
  • Date/Time: Friday, Mar. 11 at 10:15am
  • Location: Denver V
  • 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 the Firefox SQLite Manager.

This session will be most useful if: You took 'Getting started with SQL' or are familiar with 'SELECT' and 'WHERE' statements in SQL.

Speaker Bios

  • Meghan Hoyer is data editor at The Associated Press, where she analyzes data and helps disseminate national data sets to reporters across the country, guiding them to find local stories in the numbers. She previously worked at USA TODAY and The Virginian-Pilot. @meghanhoyer

Related Tipsheets

No tipsheets have yet been uploaded for this event.