Security footage shows that there were 2 witnesses. The first witness lives at the last house on "Northwestern Dr". The second witness, named Annabel, lives somewhere on "Franklin Ave".Murder tables!?
Stat 251
2025-04-01
Logistics
Submit homework 8 by midnight! Speak now with further questions or …
Focus on homework 9: Murder in SQL City
Homework 9
- Solve a murder!
Connection of homework 9 to joins
Make sure to look at the relationship between the different data sets!
The first filter statement gives you enough information to start searching for witness statements.
- Eventually you will be in the situation that you need to look up information from a different table based on a key variable. Instead of using a filter with that information, merge the two tables to directly incorporate the information from the other table.
