Summing and grouping in SQLite
The second session in the SQLite workshop will build up your SQL muscles, adding some common tasks that journalists need every day: getting counts and sums, munging the text of your data to make it more useful and structuring your data in a way that will make you more confident in the conclusions you reach.
This is the second of three SQL sessions using SQLite, but attendance at the earlier session is not required.
Troy leads the data journalism team at The Associated Press, a band of coders spread across the U.S. who love to dive into data and build tools for journalism. He's always looking for new ways to collaborate with fellow journalists at other news orgs, so hit him up with ideas. He's based in New Orleans, and like most New Orleanians, probably talks about it too much.
No tipsheets have yet been uploaded for this event.