EMPLOYEES ID Lname 1 Porter 2 3 Jalal 4 5 6 Saqr 7 Alrashidi 8 Hamdan 9 10 Mohammad Green Ameen Kamaleldeen Obiedat Fname Michael Omar Abdalla Peter Salma Rasha Malak Khalid Foad Waleed Job CEO CFO HR Officer CIO CSO Accountant PR Programmer Accountant Adviser Hiredate 01-APR-15 01-SEP-15 1 01-NOV-15 1 1 4 2 1 4 2 1 01-DEC-15 01-FEB-16 Manager Userid mporter omohamm 01-MAY-16 01-MAR-17 01-AUG-17 01-OCT-17 30-JUN-18 ajalal pgreen sameen Gender Salary 22000 1 1 1 1 2 2 2 rsagr malrash khamdan 1 fkamale 1 wobieda 1 15000 6500 14750 13500 6880 5000 8750 5750 11400 Given the Employees table above: Write a query to display the employees that earn a salary that is higher than the salary of all the programmers. Sort the results on salary from highest to lowest.
EMPLOYEES ID Lname 1 Porter 2 3 Jalal 4 5 6 Saqr 7 Alrashidi 8 Hamdan 9 10 Mohammad Green Ameen Kamaleldeen Obiedat Fname Michael Omar Abdalla Peter Salma Rasha Malak Khalid Foad Waleed Job CEO CFO HR Officer CIO CSO Accountant PR Programmer Accountant Adviser Hiredate 01-APR-15 01-SEP-15 1 01-NOV-15 1 1 4 2 1 4 2 1 01-DEC-15 01-FEB-16 Manager Userid mporter omohamm 01-MAY-16 01-MAR-17 01-AUG-17 01-OCT-17 30-JUN-18 ajalal pgreen sameen Gender Salary 22000 1 1 1 1 2 2 2 rsagr malrash khamdan 1 fkamale 1 wobieda 1 15000 6500 14750 13500 6880 5000 8750 5750 11400 Given the Employees table above: Write a query to display the employees that earn a salary that is higher than the salary of all the programmers. Sort the results on salary from highest to lowest.
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question

Transcribed Image Text:EMPLOYEES
ID Lname
1 Porter
2
3 Jalal
Mohammad
4 Green
5 Ameen
6 Sagr
7
8
9
10
Alrashidi
Hamdan
Kamaleldeen
Obiedat
Fname
Michael
Omar
Abdalla
Peter
Salma
Rasha
Malak
Khalid
Foad
Waleed
Job
CEO
CFO
HR Officer
CIO
CSO
Accountant
PR
Hiredate
01-APR-15
01-SEP-15
01-NOV-15
01-DEC-15
01-FEB-16
01-MAY-16
2
01-MAR-17 1
4
2
1
Manager Userid
mporter
omohamm
Programmer 01-AUG-17
Accountant
01-OCT-17
Adviser
30-JUN-18
1
1
1
4
ajalal
pgreen
sameen
Gender Salary
22000
1
1
1
1
2
rsagr
2
malrash
2
khamdan
1
fkamale
1
wobieda 1
15000
6500
14750
13500
6880
5000
8750
5750
11400
Given the Employees table above:
Write a query to display the employees that earn a salary that is higher than the salary of all the programmers. Sort the results on salary from highest to lowest.
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps

Knowledge Booster
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.Recommended textbooks for you

Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON

Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON

C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON

Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning

Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education