Specify the following additional queries on the database of Figure 3.5 in SQL. Show the query results
Question:
(a) For each department whose average employee salary is more than $30,000, retrieve the department name and the number of employees working for that department.
(b) Suppose we want the number of male employees in each department rather than all employees (as in Exercise 5.4a). Can we specify this query in SQL? Why or why not?
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Fundamentals of Database Systems
ISBN: 978-0136086208
6th edition
Authors: Ramez Elmasri, Shamkant Navathe
Question Posted: