SQL 2: Grouping and summing data (repeat)

  • Event: 2019 CAR Conference
  • Speaker: Dave Sheingold of independent journalist
  • Date/Time: Saturday, Mar. 9 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

  • Dave is a freelance data journalist who recently decided to  leave the Bergen Record in New Jersey after 18 years as data reporter, co-manager, and then manager, of the newspaper's data operation. He also teaches at Columbia University, hikes the national parks, plays endless softball, takes pictures and repairs antique phonographs. @davesheingold

Related Tipsheets

No tipsheets have yet been uploaded for this event.