Assume that there are two countries, America and Europe, both producing food and cloth- ing from land and labor. America is relatively abundantly endowed with land, compared to Europe, and land is used more intensively in the production of food than in the production of clothing. Draw production possibility frontiers, and indifference curves for America and Europe, and then use them to illustrate and explain the movement to the free-trade equilibrium pattern of production, consumption, trade and the gains from trade for the two countries.

A. Connect to the Oracle XE database using SQL*Plus using the JUSTLEE account and complete the tasks below [150 marks] Note: Make sure you have run the CityJail_8.sql script from Chapter 8. This script makes all database objects available for completing this case study. The following list reflects current data requests from city managers. Provide the SQL statement to satisfy each request. Test the statements and show execution results. 1. List the following information for all crimes that have a period greater than 14 days between the date charged and the hearing date: crime ID, classification, date charged, hearing date, and number of days between the date charged and the hearing date. 2. Produce a list showing each active police officer and his or her community assignment, indicated by the second letter of the precinct code. Display the community description listed in the following chart, based on the second letter of the precinct code. Second Letter of Precinct Code Description Shady Grove Center City Bay Landing 3. Produce a list of sentencing information to include criminal ID, name (displayed in all uppercase letters), sentence ID, sentence start date, and length in months of the sentence. The number of months should be shown as a whole number. The start date should be displayed in the format "December 17, 2009." 4. A list of all amounts owed is needed. Create a list showing each criminal name, charge ID, total amount owed (fine amount plus court fee), amount paid, amount owed, and payment due date. If nothing has been paid to date, the amount paid is NULL. Include only criminals who owe some amount of money. Display the dollar amounts with a dollar sign and two decimals. 5. Display the criminal name and probation start date for all criminals who have a probation period greater than two months. Also, display the date that's two months from the beginning of the probation period, which will serve as a review date. 6. An INSERT statement is needed to support users adding a new appeal. Create an INSERT statement using substitution variables. Note that users will be entering dates in the format of a two-digit month, a two-digit day, and a four-digit year, such as "12 17 2009." In addition, a sequence named APPEALS_ID_SEQ exists to supply values for the Appeal_ID column, and the default setting for the Status column should take effect (that is, the DEFAULT option on the column should be used). Test the statement by adding the following appeal: crime_ID = 25344031, filing date = 02 13 2009, and hearing date = 02 27 2009.