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 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
No tipsheets have yet been uploaded for this event.