Use the tables in your schema. Create a report showing: First name, last name, and salary of all of the employees who make over $11,000. Use a column command to format the salary to have a heading of "Emp Salary", and left justify it. Put the salaries into a currency format: $9,999,999.99 Sort the report by salary in descending sequence. Turn the TTITLE and BTITLE off after the query and clear the salary column so that it doesn't affect other queries. Create the following header for the report: left-justified: 'Run date: ' use _DATE command centered: Show the user who ran the query as 'Run by: ' SQL.USER right-justified: Put Page number on the right as 'Page: ' SQL.PNO Create the following footer for the report: centered: 'End of Report
ICS 120X01_W21.JOBS P. JOB_ID VARCHAR2(10 BYTE) JOB_TITLE VARCHAR2 (35 BYTE) MIN_SALARY NUMBER (0) MAX_SALARY NUMBER (6) JOB_ID_PK (JOD_ID) JOB_ID_PK (JOB_ID) JOB_ID ICS120XD1 W21.EMPLOYEES P. EMPLOYEE_ID NUMBER (6) FIRST_NAME VARCHAR2 (20 BYTE) LAST_NAME VARCHAR2 (25 BYTE) U EMAIL VARCHAR2 (25 BYTE) PHONE_NUMBER VARCHAR2 (20 BYTE) HIRE_DATE DATE VARCHAR2(10 BYTE) SALARY NUMBER (82) COMMISSION_PCT NUMBER (22) MANAGER_ID NUMBER (6) DEPARTMENT ID NUMBER (4) EMP_EMAIL_UK (EMAIL) EMP_EMP_ID_PK (EMPLOYEE_ID) EMP_DEPT_FK (DEPARTMENT_ID) EMP_JOB_FK (JOB_ID) EMP_MANAGER_FK (MANAGER_ID) EMP_DEPARTMENT_IX (DEPARTMENT_ID) EMP_EMAIL_UK (EMAIL) EMP_EMP_ID_PK (EMPLOYEE_ID) EMP_JOB_IX (JOB_ID) EMP_MANAGER_IX (MANADER_ID) EMP_NAME_IX (LAST_NAME, FIRST_NAME) Column Names ICS120X01_W21.JOB_HISTORY KPF EMPLOYEE_ID NUMBER (0) PSTART_DATE DATE * END_DATE DATE FJOB_ID VARCHAR2(10 BYTE) F DEPARTMENT_ID NUMBER (4) JHIST_EMP_ID_ST_DATE_PK (EMPLOYEE_ID, START_DATE) JHIST_DEPT_FK (DEPARTMENT_ID) JHIST_EMP_FK (EMPLOYEE_ID) JHIST_JOB_FK (OB_ID) JHIST_DEPARTMENT_IX (DEPARTMENT_ID) JHIST_EMPLOYEE_IX (EMPLOYEE_ID) JHIST_EMP_ID_ST_DATE_PK (EMPLOYEE_ID. START_DATE) JHIST JOB_IX (JOB_ID) Primary key Constraint Name Foreign Key Constraint Names ICS120 X01_W21. DEPARTMENTS P. DEPARTMENT ID NUMBER (4) DEPARTMENT_NAME VARCHAR2 (30 BYTE) F MANAGER_ID NUMBER (0) F LOCATION_ID NUMBER (4) DEPT_ID_PK (DEPARTMENT_ID) DEPT_LOC_FK (LOCATION_ID) DEPT_MGR_FK (MANAGER_ID) DEPT_ID_PK (DEPARTMENT_ID) DEPT_LOCATION_IX (LOCATION_ID) Index Names OM - CITY ICS120X01_W21. LOCATIONS P LOCATION_ID NUMBER (4) STREET_ADDRESS VARCHAR2 (40 BYTE) POSTAL_CODE VARCHAR2(12 BYTE) VARCHAR2 (30 BYTE) STATE_PROVINCE VARCHAR2 (25 BYTE) F COUNTRY_ID CHAR 2 BYTE) >> LOC_ID_PK (LOCATION_ID) LOC_C_ID_FK (COUNTRY_ID) LOC_CITY_UX (CITY) LOC_COUNTRY_IX (COUNTRY_ID) LOC_ID_PK (LOCATION_ID) LOC_STATE_PROVINCE_IX (STATE_PROVINCE) ICS 120X01_W21.COUNTRIES P. COUNTRY_ID CHAR 2 BYTE) COUNTRY_NAME VARCHAR2 (40 BYTE) REGION_ID NUMBER COUNTRY_C_ID_PK (COUNTRY_ID) COUNTR_REO_FK (REGION_ID) ICS120X01_W21 REGIONS P. REGION_ID NUMBER REGION NAME VARCHAR2 (26 BYTE) REG_ID_PK (REGION_ID) REG_ID_PK (REGION_ID) ICS 120X01_W21.JOBS P. JOB_ID VARCHAR2(10 BYTE) JOB_TITLE VARCHAR2 (35 BYTE) MIN_SALARY NUMBER (0) MAX_SALARY NUMBER (6) JOB_ID_PK (JOD_ID) JOB_ID_PK (JOB_ID) JOB_ID ICS120XD1 W21.EMPLOYEES P. EMPLOYEE_ID NUMBER (6) FIRST_NAME VARCHAR2 (20 BYTE) LAST_NAME VARCHAR2 (25 BYTE) U EMAIL VARCHAR2 (25 BYTE) PHONE_NUMBER VARCHAR2 (20 BYTE) HIRE_DATE DATE VARCHAR2(10 BYTE) SALARY NUMBER (82) COMMISSION_PCT NUMBER (22) MANAGER_ID NUMBER (6) DEPARTMENT ID NUMBER (4) EMP_EMAIL_UK (EMAIL) EMP_EMP_ID_PK (EMPLOYEE_ID) EMP_DEPT_FK (DEPARTMENT_ID) EMP_JOB_FK (JOB_ID) EMP_MANAGER_FK (MANAGER_ID) EMP_DEPARTMENT_IX (DEPARTMENT_ID) EMP_EMAIL_UK (EMAIL) EMP_EMP_ID_PK (EMPLOYEE_ID) EMP_JOB_IX (JOB_ID) EMP_MANAGER_IX (MANADER_ID) EMP_NAME_IX (LAST_NAME, FIRST_NAME) Column Names ICS120X01_W21.JOB_HISTORY KPF EMPLOYEE_ID NUMBER (0) PSTART_DATE DATE * END_DATE DATE FJOB_ID VARCHAR2(10 BYTE) F DEPARTMENT_ID NUMBER (4) JHIST_EMP_ID_ST_DATE_PK (EMPLOYEE_ID, START_DATE) JHIST_DEPT_FK (DEPARTMENT_ID) JHIST_EMP_FK (EMPLOYEE_ID) JHIST_JOB_FK (OB_ID) JHIST_DEPARTMENT_IX (DEPARTMENT_ID) JHIST_EMPLOYEE_IX (EMPLOYEE_ID) JHIST_EMP_ID_ST_DATE_PK (EMPLOYEE_ID. START_DATE) JHIST JOB_IX (JOB_ID) Primary key Constraint Name Foreign Key Constraint Names ICS120 X01_W21. DEPARTMENTS P. DEPARTMENT ID NUMBER (4) DEPARTMENT_NAME VARCHAR2 (30 BYTE) F MANAGER_ID NUMBER (0) F LOCATION_ID NUMBER (4) DEPT_ID_PK (DEPARTMENT_ID) DEPT_LOC_FK (LOCATION_ID) DEPT_MGR_FK (MANAGER_ID) DEPT_ID_PK (DEPARTMENT_ID) DEPT_LOCATION_IX (LOCATION_ID) Index Names OM - CITY ICS120X01_W21. LOCATIONS P LOCATION_ID NUMBER (4) STREET_ADDRESS VARCHAR2 (40 BYTE) POSTAL_CODE VARCHAR2(12 BYTE) VARCHAR2 (30 BYTE) STATE_PROVINCE VARCHAR2 (25 BYTE) F COUNTRY_ID CHAR 2 BYTE) >> LOC_ID_PK (LOCATION_ID) LOC_C_ID_FK (COUNTRY_ID) LOC_CITY_UX (CITY) LOC_COUNTRY_IX (COUNTRY_ID) LOC_ID_PK (LOCATION_ID) LOC_STATE_PROVINCE_IX (STATE_PROVINCE) ICS 120X01_W21.COUNTRIES P. COUNTRY_ID CHAR 2 BYTE) COUNTRY_NAME VARCHAR2 (40 BYTE) REGION_ID NUMBER COUNTRY_C_ID_PK (COUNTRY_ID) COUNTR_REO_FK (REGION_ID) ICS120X01_W21 REGIONS P. REGION_ID NUMBER REGION NAME VARCHAR2 (26 BYTE) REG_ID_PK (REGION_ID) REG_ID_PK (REGION_ID)
