List all employees and their join date. If an employee joined before 2007, show 'Senior Staff' in the last column of the output. Otherwise, show 'Junior Staff' (hint: use set operator). Order the output based on the joined date where the more recent joined employee comes first

 

2: List the name of all employees and the duration of their job as IT_PROG, both as current or past position. Show the most experienced employee first 

 

Transcribed Image Text:

LOCATIONS P LOCATION_ID IF STREET_ADDRESS POSTAL CODE CITY STATE_PROVINCE COUNTRY ID NUMERIC (4) VARCHAR (40) VARCHAR (12) VARCHAR (30) VARCHAR (25) CHAR (2) COUNTRIES COUNTRY_ID CHAR (2) COUNTRY_NAME VARCHAR (40) NUMERIC IF REGION_ID OH PF EMPLOYEE_ID P * START_DATE * END_DATE JOB_ID F DEPARTMENT_ID F F JOB_HISTORY * ⒸHP DEPARTMENT_ID DEPARTMENT_NAME DEPARTMENTS MANAGER_ID LOCATION_ID NUMERIC (6) Date (7) Date (7) VARCHAR (10) NUMERIC (4) REGION_ID REGION_NAME REGIONS NUMERIC (4) VARCHAR (30) NUMERIC (6) NUMERIC (4) NUMERIC VARCHAR (25) Но -IH +H P OHU sk IF IF JOB_ID JOB_TITLE MIN_SALARY MAX SALARY JOBS * EMAIL FJOB_ID SALARY I EMPLOYEE_ID FIRST NAME LAST_NAME VARCHAR (10) VARCHAR (35) NUMERIC (6) NUMERIC (6) EMPLOYEES PHONE NUMBER HIRE_DATE COMMISSION_PCT MANAGER_ID DEPARTMENT_ID NUMERIC (6) VARCHAR (20) VARCHAR (25) VARCHAR (25) VARCHAR (20) Date (7) VARCHAR (10) NUMERIC (8,2) NUMERIC (2,2) NUMERIC (6) NUMERIC (4) OH 1 1 1 1 I LOCATIONS P LOCATION_ID IF STREET_ADDRESS POSTAL CODE CITY STATE_PROVINCE COUNTRY ID NUMERIC (4) VARCHAR (40) VARCHAR (12) VARCHAR (30) VARCHAR (25) CHAR (2) COUNTRIES COUNTRY_ID CHAR (2) COUNTRY_NAME VARCHAR (40) NUMERIC IF REGION_ID OH PF EMPLOYEE_ID P * START_DATE * END_DATE JOB_ID F DEPARTMENT_ID F F JOB_HISTORY * ⒸHP DEPARTMENT_ID DEPARTMENT_NAME DEPARTMENTS MANAGER_ID LOCATION_ID NUMERIC (6) Date (7) Date (7) VARCHAR (10) NUMERIC (4) REGION_ID REGION_NAME REGIONS NUMERIC (4) VARCHAR (30) NUMERIC (6) NUMERIC (4) NUMERIC VARCHAR (25) Но -IH +H P OHU sk IF IF JOB_ID JOB_TITLE MIN_SALARY MAX SALARY JOBS * EMAIL FJOB_ID SALARY I EMPLOYEE_ID FIRST NAME LAST_NAME VARCHAR (10) VARCHAR (35) NUMERIC (6) NUMERIC (6) EMPLOYEES PHONE NUMBER HIRE_DATE COMMISSION_PCT MANAGER_ID DEPARTMENT_ID NUMERIC (6) VARCHAR (20) VARCHAR (25) VARCHAR (25) VARCHAR (20) Date (7) VARCHAR (10) NUMERIC (8,2) NUMERIC (2,2) NUMERIC (6) NUMERIC (4) OH 1 1 1 1 I

Answer rating: 100% (QA)

To solve these problems you would typically use SQL queries to retrieve information from a database based on the schema provided However I cannot dire... View the full answer