– Bonus – 4 pts - You can Do any 5 of the 11 questions listed on pages 293 and 2

Question

– Bonus – 4 pts - You can Do any 5 of the 11 questions listed on pages 293 and 294

Please make sure that you number the questions that you are answering so I know what's going on??

1. .......

3. ........

and so on

Here is the ch. 8 script we were given:

?? @ oracle-1 2c-sal.pdf × + O nfile:///C/Users/james/Desktop/oracle_12c_sql.pdf 316 of 627 include any book seling for less than $45.00 For each request, create a document showing the SQL statement and the query results. Case Study: City Jail Note: Run the CityJail 8.sql file provided by your instructor to ensure that all necessary tables and constraints are available for this case study. This script isn't included in student data files because case study assignments in previous chapters include table creation challenges. This script rebuilds the City Jail database. Don't be concemed with errors from the DROP TABLE commands, which delete any existing tables of the same nameS delete anue Dont be The following list reflects common data requests from city managers. Write the SQL statements to satisfy the requests. If the query can be accomplished by using different operators, supply altemative solutions so that the performancetuning group can test them and identify the more efficient statements. Test the statements and show xecution results List all criminal aliases beginning with the letter B. ID, criminal ID, date charged, and classification. ID, date charged, and status (were charged) 3. List all crimes with a status of CA (can appeal) or IA in appeal). List the crime ID, criminal 4. List all crimes classified as a felony. List the crime ID, criminal ID, date charged, and 5. List all crimes with a hearing date more than 14 days after the date charged. List the crime 6. List al criminals with the zip code 23510. List the criminal ID, last name, and zip code. Sort 7. List all crimes that don't have a hearing date scheduled. List the crime ID, criminal ID, date 8List all sentences with a probation officer assigned. List the sentence ID, criminal ID, and ID, criminal ID, date charged, and heaning date. the list by criminal ID. charged, and hearing date. probation officer ID. Sort the list by probation officer ID and then criminal ID Restricting Rows and Sorting Data 10:10 PM O Type here to search

Explanation / Answer

3. select crime_id,criminal_id,date_charged, status from crimes where status='CA' or status='IA';
4. select crime_id,criminal_id,date_charged, classification from crimes where classification='F';

6. select criminal_id, last, zip from criminals where zip=23510 order by criminal_id;

7. select crime_id, criminal_id, date_charged, hearing_date from crimes where hearing_date is NULL;
8. select sentence_id, criminal_id, prob_id from sentences order by prob_id, criminal_id;

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.