Question
Asked Nov 12, 2019
27 views
  1. Find those job categories whose maximum salary among the people hired after 1980 is more than 2500
  2. Find the average salary of those employees whose name starts with J in each department
  3. Find the most recent employment among those hired before 1980 for each department
EMP:
NUMBER (4)
EMPNO
VARCHAR2 (10)
ΕΝΑΜΕ
VARCHAR2 (9)
JOB
NUMBER (4)
MGR
HIREDATE
DATE
NUMBER (7, 2)
SAL
NUMBER (7, 2)
СOMM
NUMBER (2)
DE PTNΟ
DEPT:
NUMBER (2)
DE PTNΟ
VARCHAR2 (14)
DNAME
VARCHAR2 (13)
LOC
help_outline

Image Transcriptionclose

EMP: NUMBER (4) EMPNO VARCHAR2 (10) ΕΝΑΜΕ VARCHAR2 (9) JOB NUMBER (4) MGR HIREDATE DATE NUMBER (7, 2) SAL NUMBER (7, 2) СOMM NUMBER (2) DE PTNΟ DEPT: NUMBER (2) DE PTNΟ VARCHAR2 (14) DNAME VARCHAR2 (13) LOC

fullscreen
check_circle

Expert Answer

Step 1

1)

To find those job categories whose maximum salary among the people hired after 1980 is more than 2500, the following query is used.

select JOB from EMP where SAL>2500 and to_char(hiredate,'YYYY') > ‘1980’;

Step 2

2)

To find the average salary of those employees whose name starts with “J” in each department, the fol...

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in

Engineering

Computer Science

Related Computer Science Q&A

Find answers to questions asked by student like you
Show more Q&A
add
question_answer

Q: A two-dimensional random walk simulates the behavior of a particle moving in a grid of points. At ea...

A: A java program that takes an integer command-line argument “n” and simulates the motion of a random ...

question_answer

Q: A double-ended queue or deque is a generalization of a stack and a queue that supports adding and re...

A: Program descriptionThe answer for part-1 cannot be attempted as interface and skeleton has not been ...

question_answer

Q: Explain how a stateless firewall would block all incoming and outgoing HTTP requests.

A: Stateless firewall blocks all incoming and outgoing HTTP requests:Initially the user sends request t...

question_answer

Q: X-Kingdom has trapped n number of soldiers of their opponent. They want to execute them. They create...

A: C Program:// Include the header files#include<stdio.h>#include<stdlib.h>// Declare and i...

question_answer

Q: whats is the length of UDP?

A: The given User Datagram Protocol header is 12 03 00 0F 00 1E A3 10.The UDP (User Datagram Protocol) ...

question_answer

Q: Shipping is free for online orders totaling $25 or more at Mississippi.com. Orders less than $25 are...

A: Note: You didn't mention any language so i use Python#get the inputs from the userunit_cost = float(...

question_answer

Q: Given the follwing business rules, create an Crows Foot ERD.  The ERD must include all primary keys,...

A: The crow’s foot diagram shows the entities as the boxes and relationship as the lines between the en...

question_answer

Q: How do I code this on python heres the problem  Use the Design Recipe to define a function count_val...

A: Programming instructions: Define the function count_value which takes the list and a value as an arg...

question_answer

Q: For each of the following page replacement policies, list the total number of page faults and fill i...

A: Answer:a. LRU replacement: