Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Q.No . 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.

Q.No . 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.

Oracle 12c: SQL
Oracle 12c: SQL
3rd Edition
ISBN:9781305251038
Author:Joan Casteel
Publisher:Joan Casteel
Chapter4: Constraints
Section: Chapter Questions
Problem 8HOA: Create a table named REP_CONTRACTS containing the columns listed in the following chart A composite...
See similar textbooks
icon
Related questions
Question

Q.No . 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.
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Fundamentals of Datawarehouse
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS