Quiz: Homicide/Art of Access Readings Part 2 and More
Quiz covering chapters 3, 4, 5 of “Homicide” and “Art of Access”. And some SQL.
Fill out the answers on a blank sheet of paper!
Write your SUNET id on the paper, please
Writing on paper today!
- A few questions from chapters 3, 4, 5, from Homicide.
- 1 short-answer question from Art of Access
- 2 questions involving writing SQL from scratch.
For a homicide detective, what is “better than being good”?
What is the cap on overtime pay for a Balitmore homicide detective before he/she’s taken off the rotation?
50 percent of the detective’s base pay.
20 percent of the detective’s base pay.
100 percent of the detective’s base pay.
Fill in the blanks for this aphorism about how murders are solved.
In reference to the color of money, and the colors by which open and solved murders are chronicled on the board, the rule states:
First they’re __. Then they’re green. Then they’re _____.
Describe with a couple sentences what a retention schedule is, in regards to public records (Chapter 4: Art of Access). Feel free to include a few examples.
Given a table named
people that looks like this:
Write a SQL query that selects from the
people table and ends with this resulting table:
Same table and format as the previous question, except write the query to get this result:
Hint: it requires a couple of aggregation functions and aliasing. But no
A (50 Percent of Base Pay)
First they go "red"...then they go "green"...then they go "black"
The retention schedule can be thought of as the "life span" of a public record. It dictates exactly how long, at a minimum, an agency must keep a public record before destroying it.
SELECT age FROM people WHERE age = 60;
SELECT AVG(age) AS avg_age, COUNT(*) AS peeps FROM people;