Bartleby the Scrivener
computer science
Consider the following relations:
EMP_NO
EMP_NAME
EMP_GRADE
JOB_ID
DEPTNO
START_DATE
EMP
DEPTNO
DEPTNAME
LOC
LOW_SAL
HIGH_SAL
DEPT
- Display the name concatenated with the job ID, separated by a comma and space, and name the column Employee and Title.
- Display the employee name, employee No and start date of employees hired between February 1998, and May 1998. Order the query in ascending order by start date.
- Create a unique listing of all jobs that are in department 80. Include the location of the department in the output.
- Write a query to display job ID, total salary and employee name whose job_id contains “REP” and total salary is above 13000. Display the data in ascending order according to total salary.
- Create a query that displays the employees’ last names and indicates the amounts of their annual salaries with asterisks. Each asterisk signifies a thousand dollars.