Question

Let's say we have the attached table :

 

Find the year in which employees hired with minimum salary more than 1000

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

Image Transcription

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

Expert Answer

Want to see the step-by-step answer?

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times may vary by subject and question complexity. Median response time is 34 minutes for paid subscribers and may be longer for promotional offers.
Tagged in
Engineering
Computer Science

Related Computer Science Q&A

Find answers to questions asked by students like you.

Q: Compare and contrast iOS and Android mobile operating systems. Which one is better?

A: Comparison of Android and iOS:

Q: Create 10 echo statements introducing yourself, your major , your favorite color , your dream vacati...

A: The echo statement is used in PHP to print the data to the output screen.echo statement has no retur...

Q: What are the mantissa and exponent of 6.75 in 8-bit floating point binary system?

A: The given number is 6.75First, convert it in binary form.Binary form of 6 is 110Binary form of 0.75 ...

Q: What is the value of sum and count after the execution of the following while loop? (All variables a...

A: Value of sum and countIn the program, count = 15. In the while loop, the statement count<=15 beco...

Q: Write a system calls your program is allowed to use: fprintf(), open(), fgets(), and fclose(). Do no...

A: System calls:A system call can be defined as a request to do something to the operating system on be...

Q: (select all that apply) In MS Access, to ensure that a grade must be either A, B, C, D or F, whichva...

A: Validation rule:In MS Access, the validation rule used to ensure the grade that must be either A, B,...

Q: I need help with this programming exercise:   Write a C++ console application that allows your user ...

A: Program code #1:

Q: Double any element's value that is less than minValue. Ex: If minValue = 10, then dataPoints = {2, 1...

A: Completing the given C++ program so, that it can follow the given rubrics:The array is already decla...

Q: Write a method named sumInts that can take a variable number of int arguments and return the sum of ...

A: Below is the approach, and a java program to display the sum of integer arguments, passed in the sum...