Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using the Baltimore Crime data (yes this is real data as reported by the city of Baltimore Maryland). Create a query to: 1. Find the
Using the Baltimore Crime data (yes this is real data as reported by the city of Baltimore Maryland). Create a query to: 1. Find the number of crimes using a Firearm for 2019 (10 points). 2. Find the number of crimes by district for 2019 and 2018 separately (10 points). 3. Find the number of Firearm crimes by Neighborhood by year (you may want to use year0 function first to extract year from a date variable) (20 points). 4. Find the number of Firearm crimes by year (1 0 points). 5. Use CrimeCode to find the number of Aggravated Assaults by month (15 points). 6. Use CrimeCode to find the number of Common Assaults by year {15 points). 7. Create a dataset that has year, number of Aggravated Assaults and number of Common Assaults {15 points). These tasks must all be done using SQL. Note that you should import your data into the work directory and name the imported dataset BaItCrime. You must save and submit your code using this naming convention \"Proj#_Firstname_Lastname .533" {5 points)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started