Find the first names and last names of employees if they got a salary increase more than 10% in the first month of 2000 together with their salary change dates, old salaries, new salaries, and increase percentages in descending order by their increase percentages.
Find the first names and last names of employees if they got a salary increase more than 10% in the first month of 2000 together with their salary change dates, old salaries, new salaries, and increase percentages in descending order by their increase percentages.
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
![Suppose that you are given a database that records information about human
resources of a large multi-national company. You can find the enhanced en-
tity relationship diagram of this database below. Answer the following question
by writing am SQL query on this database. You are given an example output
for the question. Records with '9999-01-01’ as their to date attribute are the
current ones.
salaries
employees
titles
emp_no INT(11)
emp_no INT(11)
emp_no INT(11)
salary INT(11)
O birth_date DATE
%23
title VARCHAR(50)
from_date DATE
first_name VARCHAR(14)
from_date DATE
to_date DATE
last_name VARCHAR(16)
O to_date DATE
Indexes
gender ENUM(M', F)
Indexes
PRIMARY
hire_date DATE
PRIMARY
PRIMARY
dept emp
emp_no INT(11)
dept_manager
Kdept_no CHAR(4)
O from_date DATE
emp_no INT(11)
departments
dept_no CHAR(4)
dept_no CHAR(4)
to date DATE
O from_date DATE
O dept_name VARCHAR(40)
KIndexes
O to_date DATE
Indexas
PRIMARY
Indexes
PRIMARY
dept_no
PRIMARY
dept_name
dept no
Find the first names and last names of employees if they got a salary increase
more than 10% in the first month of 2000 together with their salary change
dates, old salaries, new salaries, and increase percentages in descending order
by their increase percentages.
modoto
new salary
percentage](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F40547f5e-c5fb-4cbb-9263-6bbe5ad47f39%2F29ddc522-fff3-425b-828a-1a82e8f1d5e3%2Fisqvd0c_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Suppose that you are given a database that records information about human
resources of a large multi-national company. You can find the enhanced en-
tity relationship diagram of this database below. Answer the following question
by writing am SQL query on this database. You are given an example output
for the question. Records with '9999-01-01’ as their to date attribute are the
current ones.
salaries
employees
titles
emp_no INT(11)
emp_no INT(11)
emp_no INT(11)
salary INT(11)
O birth_date DATE
%23
title VARCHAR(50)
from_date DATE
first_name VARCHAR(14)
from_date DATE
to_date DATE
last_name VARCHAR(16)
O to_date DATE
Indexes
gender ENUM(M', F)
Indexes
PRIMARY
hire_date DATE
PRIMARY
PRIMARY
dept emp
emp_no INT(11)
dept_manager
Kdept_no CHAR(4)
O from_date DATE
emp_no INT(11)
departments
dept_no CHAR(4)
dept_no CHAR(4)
to date DATE
O from_date DATE
O dept_name VARCHAR(40)
KIndexes
O to_date DATE
Indexas
PRIMARY
Indexes
PRIMARY
dept_no
PRIMARY
dept_name
dept no
Find the first names and last names of employees if they got a salary increase
more than 10% in the first month of 2000 together with their salary change
dates, old salaries, new salaries, and increase percentages in descending order
by their increase percentages.
modoto
new salary
percentage
![first_name
last_name
change date old salary new salary percentage
11.2325
Jacqueline
Kaijung
Gro
Isaac
2000-01-11
40000
44493
Hatcliff
2000-01-20
40113
44613
11.2183
Hebert
2000-01-12
40000
44449
11.1225
Kristen
Matteis
2000-01-16
43955
48360
10.0216
Alenka
Sifakis
2000-01-19
41405
45550
10.0109
Hairong
Caine
2000-01-16
41798
45982
10.0100](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F40547f5e-c5fb-4cbb-9263-6bbe5ad47f39%2F29ddc522-fff3-425b-828a-1a82e8f1d5e3%2Fizc0kw5_processed.jpeg&w=3840&q=75)
Transcribed Image Text:first_name
last_name
change date old salary new salary percentage
11.2325
Jacqueline
Kaijung
Gro
Isaac
2000-01-11
40000
44493
Hatcliff
2000-01-20
40113
44613
11.2183
Hebert
2000-01-12
40000
44449
11.1225
Kristen
Matteis
2000-01-16
43955
48360
10.0216
Alenka
Sifakis
2000-01-19
41405
45550
10.0109
Hairong
Caine
2000-01-16
41798
45982
10.0100
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
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 2 steps with 3 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
![Concepts of Database Management](https://www.bartleby.com/isbn_cover_images/9781337093422/9781337093422_smallCoverImage.gif)
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
![Prelude to Programming](https://www.bartleby.com/isbn_cover_images/9780133750423/9780133750423_smallCoverImage.jpg)
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
![Sc Business Data Communications and Networking, T…](https://www.bartleby.com/isbn_cover_images/9781119368830/9781119368830_smallCoverImage.gif)
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY