Consider the following relations: 

EMP_NO

EMP_NAME

EMP_GRADE

JOB_ID

DEPTNO

START_DATE

EMP

DEPTNO

DEPTNAME

LOC

LOW_SAL

HIGH_SAL

DEPT

1. Display the name concatenated with the job ID, separated by a comma and space, and name the column Employee and Title.
2. 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.
3. Create a unique listing of all jobs that are in department 80. Include the location of the department in the output.
4. 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.
5. 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.

 

Answer rating: 100% (QA)

Drop table if it already exists DROP TABLE EMP DROP TABLE DEPT DROP TABLE JOB Create New table Create table EmpEMPNO int Primary key EMPNAME varchar30... View the full answer