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.

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!