Question: 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 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)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Ryan is 26 years old and weighs 213 pounds. He works a full-time construction job during the day and squeezes in online classes at the community college in the evenings. He recently started working...

need a help on understanding this sql problems. Question 7 Use the tables in your schema. Alter the previous query to print out the average salary for all departments, showing the department name....

Question 7 Use the tables in your schema. Alter the previous query to print out the average salary for all departments, showing the department name. (Hint: use the "group by" clause see p121 of text)...

Suppose you work at a bank as a data analyst. Your main job is to analyze the data stored in their database. The database has five tables, whose schema is shown as below. Primary keys attributes are...

1. Find the names of all people who work in the Consulting department. 2. Find the names of all people who work in the Consulting department and who spend more than 20% of their time on the project...

Name the range N 2 1 :P 3 1 "Name Lookup" Use VLOOKUP formulas to find an exact match for the First and Last names of the employees based on their employee numbers. ( Hint: use the range name or be...

Three data components are asked in this question:gender, department, and salary (drop the latter in the items field). After you have created the pivot table and have chosen the field settings to...

PLEASE HELP!!! EMERGENCY!!! ALL SALES YEAR: NUMBER(22) MONTH NUMBER(22) PRD_TYPE_ID: NUMBER(22) EMP_ID: NUMBER(22) AMOUNT: NUMBER(8,2) JOBS +JOB_ID: CHAR(3) NAME: VARCHAR2(20) EMPLOYEES +EMPLOYEE_ID:...

1)Find the average salary for employees in the IT department (the department name will be 'IT'). Label this column as "Avg Sal". Format the result to display in dollars using commas (for thousands)...

kodu doru dzgn yazlsn ka kere gnderdik almyor. - You should submit whole java project file in zipped format and project report, named project file as studentNo_NameSurname_Project. Project report...

Problem Description: CEO of Factory X make a request to your software company about design a program with user interface. The program should calculate Factory X's payment amount which will be made...

Andy Posey asks you to analyze the operating cost of his lawn services business. He has bought the needed equipment with a cash payment of $45,000. Upon your recommendation, he agrees to adopt...

You are planning on taking a loan for $ 58 ,000. You will repay the loan in annual payments over the next 16 years and the loan has a stated interest rate of 12 %. For the very last payment on your...

The cash flow cycle has a major bearing on the firm's Question 6 Select one: a . dividend policy. b . liquidity. c . cash management efficiency. d . risk.

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

4. Do you have power relative to this person? Why or why not? Do you need or want more power in this case? If yes, then what are some of the ways in which you might increase your influence and power?

1. On balance, do you think networking is best thought of as a way to meet interesting people or a way of using people to get what you want?

2. Have you ever been offended by someone seeking to network with you? If so, what was it about the interaction that bothered you?