This lesson is adapted from information provided by Investigative Reporters and Editors. Much of the following includes IRE practice data for the purpose of training. I've included additional info to further clarify difficult concepts and to make it a little bit fun.
Queries in the movies
For part 2 of this intro to SQL, we'll tackle how to group, sum and count. Part 3 will cover how to join.
Keeping with the data about US dams from the previous lesson, let's think of a few additional questions and then translate them into queries, this time . . .
Load a dataset into Firefox's SQLite Manager extension and start running queries to find the exact bits of info you need to concretely support your reporting.
Explain Firefox's database management extension, SQLite Manager.
Demo how to use the
SELECTstatement and the
FROMcommand to find and view specific data.
Demo how to filter data using the
Demo how to sort data using the
Open floor for questions.
Hand off to Part . . .