SQL 2: Grouping and summing data
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.
Matt Kiefer is the data editor for The Chicago Reporter, a non-profit newsroom that investigates issues of race and poverty. He's also the creator of FOIAMail, an open-source FOIA automation project. @matt_kiefer
No tipsheets have yet been uploaded for this event.