PADJO 2017 SQL Exam

Now with extra election and disbursement data!

Due date: Wednesday of Finals Week, 11:59PM

The database to use:

padjo-2017-exam.sqlite

Table of Contents generated with DocToc

• Instructions
• Exam
• Background

---

Instructions

Create a Google Doc named:

padjo-2017-final-sql-exam-your_sunet_id

Share it with me, and also email it to me.

This Google Doc should have this format:

• One page per question
• First line of the page should be the question number, e.g. A02
• The rest of the page should just be the query that answers the prompt.
• Put the query in a monospace font (such as Courier)
• The query should return exactly the expected result, that includes the order and naming of the columns. Don't deviate.

Sample exam

Exam

The database to use: padjo-2017-exam.sqlite

• Sorting and Filtering
• Aggregation
• Joins

---

Background

https://projects.propublica.org/represent/expenditures

https://www.dailykos.com/stories/2017/1/30/1627319/-Daily-Kos-Elections-presents-the-2016-presidential-election-results-by-congressional-district

https://docs.google.com/spreadsheets/d/1E0TjIyMXNitEkUVySvelLBKhoOlkfPxmcB4U7nHybQo/edit#gid=1686856399