Define the following additional queries in SQL. to watch Query results if applied to a database. (a) per department employee average salary over $30,000, Retrieve the name of the department and the number of its employees. (b) Suppose we want the number of male employees in each department, can we define this query in SQL? Why and why not?
Define the following additional queries in SQL. to watch Query results if applied to a database. (a) per department employee average salary over $30,000, Retrieve the name of the department and the number of its employees. (b) Suppose we want the number of male employees in each department, can we define this query in SQL? Why and why not?
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
Define the following additional queries in SQL. to watch
Query results if applied to a
(a) per department employee average salary over $30,000,
Retrieve the name of the department and the number of its employees.
(b) Suppose we want the number of male employees in each department, can we define this query in SQL? Why and why not?
Transcribed Image Text:ΕMPLOYEΕ
Fname
Minit
Lname
Ssn
Bdate
Address
Sex Salary Super_ssn
Dno
123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555
333445555 1955-12-08 638 Voss, Houston, TX
999887777 1968-01-19 3321 Castle, Spring, TX
John
B
Smith
Franklin
Wong
M 40000 888665555
5
F 25000 987654321
43000 888665555
Alicia
J
Zelaya
Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX
4
Jennifer
F
4
Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TXM
English 453453453 1972-07-31 5631 Rice, Houston, TX
987987987 | 1969-03-29 980 Dallas, Houston, TX
38000 333445555
25000 333445555
25000 987654321
Ramesh
Joyce
Ahmad
V
Jabbar
M
4
James
E
Borg
888665555 1937-11-10 450 Stone, Houston, TX
M 55000 NULL
DEPARTMENT
DEPT_LOCATIONS
Dname
Dnumber
Mgr_ssn
Mgr_start_date
Dnumber
Dlocation
Research
5
333445555
1988-05-22
1
Houston
Administration
4
987654321
1995-01-01
4
Stafford
Headquarters
1
888665555
1981-06-19
Bellaire
Sugarland
5
Houston
WORKS_ON
PROJECT
Essn
Pno
Hours
Pname
Pnumber
Plocation
Dnum
123456789
32.5
ProductX
1
Bellaire
123456789
7.5
ProductY
Sugarland
666884444
3
40.0
ProductZ
3
Houston
453453453
20.0
Computerization
10
Stafford
4
453453453
2
20.0
Reorganization
20
Houston
333445555
10.0
Newbenefits
30
Stafford
333445555
3
10.0
333445555
10
10.0
DEPENDENT
333445555
20
10.0
Essn
Dependent_name
Sex
Bdate
Relationship
999887777
30
30.0
333445555
Alice
F
1986-04-05 Daughter
999887777
10
10.0
333445555
Theodore
M
1983-10-25
Son
987987987
10
35.0
333445555
Joy
F
1958-05-03
Spouse
987987987
30
5.0
987654321
Abner
M
1942-02-28| Spouse
987654321
30
20.0
123456789
Michael
M
1988-01-04
Son
987654321
20
15.0
123456789
Alice
F
1988-12-30
Daughter
888665555
20
NULL
123456789
Elizabeth
1967-05-05
Spouse
5
4.
5
KA
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 2 steps with 2 images
Recommended textbooks for you
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
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…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
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)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY