Skip to content

Instantly share code, notes, and snippets.

@judsonmitchell

judsonmitchell/quiz1key.md

Created February 9, 2019 20:06
Show Gist options
  • Save judsonmitchell/5d0626f93c70a2703300c33702bc1944 to your computer and use it in GitHub Desktop.
Save judsonmitchell/5d0626f93c70a2703300c33702bc1944 to your computer and use it in GitHub Desktop.
Download ZIP
Answers to Quiz 1
Raw
quiz1key.md

Quiz 1 grading key:

  1. (4 points). Directory properly created and correctly named file placed in directory
  2. (4 points). No, the file has not been modified
 
 sha256sum phone_dump.csv
  1. (4 points). There were 42 overall calls from Zaddy
SELECT *  FROM `phone_dump` WHERE `Parties` LIKE '%Zaddy%' AND `Call Type` LIKE 'Incoming'
  1. (4 points). There were three calls to Zaddy the day of the murder.
SELECT *  FROM `phone_dump` WHERE `Parties` LIKE '%Zaddy%' AND `Call Type` LIKE 'Outgoing' and `Time` LIKE '%01-May%'
  1. (4 points). Yes, Zaddy called on the day of the murder. There were 6 calls from Zaddy.
SELECT *  FROM `phone_dump` WHERE `Parties` LIKE '%Zaddy%' AND `Call Type` LIKE 'Incoming' and `Time` LIKE '%01-May%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment