use the sql to answer the floowing two question (data base code had been given below) To perform below tasks, refer to tables in the City Jail database. List all criminals along with the crime charges files. The report needs to include Criminal ID, name, Crime Code, and fine amountList all criminals along with crime status and appeal status (if applicable – sounds like an Outer join). The reports needs to include the Criminal ID, name, crime classification ,date charges , appeal filing date and appeal status. Show all criminals, regardless of whether they have filed an appeal or not.

List all criminals along with the crime charges files.The report needs to include Criminal ID, name,…

Answered: List all criminals along with the crime…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Related questions

Question

use the sql to answer the floowing two question (data base code had been given below)

To perform below tasks, refer to tables in the City Jail database.

List all criminals along with the crime charges files. The report needs to include Criminal ID, name, Crime Code, and fine amount
List all criminals along with crime status and appeal status (if applicable – sounds like an Outer join). The reports needs to include the Criminal ID, name, crime classification ,date charges , appeal filing date and appeal status. Show all criminals, regardless of whether they have filed an appeal or not.

Expert Solution