Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting

Authors: kieso, weygandt and warfield.

14th Edition

9780470587232, 470587288, 470587237, 978-0470587287

Students also viewed these Mathematics questions