SQL 2: Grouping and summing
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 will be most useful if: You took “SQL 1: Intro and filtering” or are familiar with “SELECT” and “WHERE” statements in SQL.
Madi Alexander is a computational journalist at The Dallas Morning News. She was previously a data reporter at Bloomberg Government in Washington, D.C. Madi has a master's degree in journalism from the University of Missouri. She volunteers for the Dallas puppy-raising chapter of Guide Dogs for the Blind. Madi also keeps a database of all the national parks and historical sites she has visited — a total of 40 thus far. @MadiLAlexander
No tipsheets have yet been uploaded for this event.