Question: 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
Get step-by-step solutions from verified subject matter experts
