Perform an SQL query request to search in the database to retrieve the sum of the salaries of all employees of the Research and Administration department, as well as the maximum salary, the minim salary, and the average salary in this department.

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...
icon
Related questions
Question

You are working on the new internal web system that requires that you use your expertise
search from the database to provide adequate feedback to your supervisor. The company has
centralized database which lets you organise and manage all the employee data from a single
point. With this finest employee database, the end user can easily track the Projects, Leaves,
Attendances, Timesheets, Salaries, Expenses, and more from employee. Keep the log of
employee lifecycle and examine the improvements in your workforce over the period with this
employee database management system. Use the Company_XYZ database to write the SQL
queries that solve the questions below.

 

Perform an SQL query request to search in the database to retrieve the sum of the
salaries of all employees of the Research and Administration department, as well as
the maximum salary, the minim salary, and the average salary in this department.

Sex Salary Super_san Dno
123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445505
40000 888665055
Fname
Minit
Lname
San
Bdate
Address
John
B
Smith
Franklin
Wong
333445055 1955-12-08 638 Voss, Houston, TX
M
999887777 1968-01-19 3321 Castle, Spring. TX
F 20000 987654321
Zelaya
Wallace 987654321
Alicia
4
Jenniter
1941-06-20 291 Berry, Bellaire, TX
43000 888660005
4
Ramesh K
Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M
A English
V
E Borg
38000 333445000
20000 333445555
1969-03-29 980 Dallas, Houston, TX M 23000 987604321
888660000 1937-11-10 450 Stone, Houston, TX M 0o000 NULL
Joyce
453453453 1972-07-31 5631 Rice, Houston, TX
F
Ahmad
Jabbar
987987987
4
James
1
DEPT LOCATIONS
DEPARTMENT
Dnumber
Dnumber
Dlocation
Dname
Research
Administration
Mgr_ssn
Mgr_start_date
333445050
1988-05-22
1
Houston
4.
987654321
1990-01-01
Stafford
Headquarters
888660005
1981-06-19
Bellaire
Sugarland
Houston
WORKS ON
Essn
PROJECT
Pno Hours
Pname
Pnumber Plocation
Dnum
123456789
32.5
ProductX
Bellaire
Sugarland
123406789
2
7.0
ProductY
666884444
40.0
Productz
3
Houston
Stafford
Computerization
Reorganization
Newbenefits
453403453
20.0
10
4
453403453
2
20.0
20
Houston
333445000
2
10.0
30
Stafford
4
333445000
3
10.0
333445000
10
10.0
DEPENDENT
333445000
20
10.0
Essn
Dependent_name Sex
Bdate
Relationship
999887777
30
30.0
333440005
Alice
F
1986-04-05 Daughter
999887777
10
10.0
333440000
Theodore
1983-10-25
Son
987987987
10
35.0
1958-00-03 Spouse
Joy
Abner
333440000
987987987
30
0.0
987654321
1942-02-28
Spouse
987654321
30
20.0
123456789
Michael
1988-01-04
Son
987654321
20
10.0
123456789
Alice
1988-12-30 Daughter
B88660000
20
NULL
123456789
Elizabeth
1967-05-00
Spouse
Transcribed Image Text:Sex Salary Super_san Dno 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445505 40000 888665055 Fname Minit Lname San Bdate Address John B Smith Franklin Wong 333445055 1955-12-08 638 Voss, Houston, TX M 999887777 1968-01-19 3321 Castle, Spring. TX F 20000 987654321 Zelaya Wallace 987654321 Alicia 4 Jenniter 1941-06-20 291 Berry, Bellaire, TX 43000 888660005 4 Ramesh K Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M A English V E Borg 38000 333445000 20000 333445555 1969-03-29 980 Dallas, Houston, TX M 23000 987604321 888660000 1937-11-10 450 Stone, Houston, TX M 0o000 NULL Joyce 453453453 1972-07-31 5631 Rice, Houston, TX F Ahmad Jabbar 987987987 4 James 1 DEPT LOCATIONS DEPARTMENT Dnumber Dnumber Dlocation Dname Research Administration Mgr_ssn Mgr_start_date 333445050 1988-05-22 1 Houston 4. 987654321 1990-01-01 Stafford Headquarters 888660005 1981-06-19 Bellaire Sugarland Houston WORKS ON Essn PROJECT Pno Hours Pname Pnumber Plocation Dnum 123456789 32.5 ProductX Bellaire Sugarland 123406789 2 7.0 ProductY 666884444 40.0 Productz 3 Houston Stafford Computerization Reorganization Newbenefits 453403453 20.0 10 4 453403453 2 20.0 20 Houston 333445000 2 10.0 30 Stafford 4 333445000 3 10.0 333445000 10 10.0 DEPENDENT 333445000 20 10.0 Essn Dependent_name Sex Bdate Relationship 999887777 30 30.0 333440005 Alice F 1986-04-05 Daughter 999887777 10 10.0 333440000 Theodore 1983-10-25 Son 987987987 10 35.0 1958-00-03 Spouse Joy Abner 333440000 987987987 30 0.0 987654321 1942-02-28 Spouse 987654321 30 20.0 123456789 Michael 1988-01-04 Son 987654321 20 10.0 123456789 Alice 1988-12-30 Daughter B88660000 20 NULL 123456789 Elizabeth 1967-05-00 Spouse
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
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…
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)
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
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY