Answers to Quiz 1

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
 

3. (4 points). There were 42 overall calls from Zaddy

SELECT *  FROM `phone_dump` WHERE `Parties` LIKE '%Zaddy%' AND `Call Type` LIKE 'Incoming'

4. (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%'

5. (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%'