SQL Assignment:

The citys crime analysis unit has submitted the following data requests. Provide the SQL statements to satisfy the requests. Test the statements and show the query results.

1. Show the total number of crimes reported by an officer.
2. Show the average number of crimes by status.
3. List the lowest number of crimes committed by a person.
4. Display the highest fine amount assigned to a crime charge.
5. List criminals (ID and name) who have multiple sentences assigned.
6. List the total number of crime charges successfully defended (guilty status assigned) by precinct. Include only precincts with at least six guilty charges.
7. List the total amount of collections (fines and fees) and the total amount owed by crime classification.