[Solved]75 Specify Following Queries Data Base Figure 55 Sql Show Query Re Sults Query Applied Dat Q37200624

7.5. Specify the following queries on the data base in Figure 5.5 in SQL. Show the query re sults if each query is applied to the database state in Figure 5.6 a) For each department whose average empl oyee salary is more than $30,000, retrieve th e department name and the number of empl oyees working for that department. b) Suppose that we want the number of male employees in each department making more than $30,000, rather than all employees (as in Exercise 7.5a). Can we specify this query i n SQL? Why or why not? c) For each department that has more than t hree employees, retrieve the department nu mber and the number of its employees who a re making more than $30,000. Show transcribed image text 7.5. Specify the following queries on the data base in Figure 5.5 in SQL. Show the query re sults if each query is applied to the database state in Figure 5.6 a) For each department whose average empl oyee salary is more than $30,000, retrieve th e department name and the number of empl oyees working for that department. b) Suppose that we want the number of male employees in each department making more than $30,000, rather than all employees (as in Exercise 7.5a). Can we specify this query i n SQL? Why or why not? c) For each department that has more than t hree employees, retrieve the department nu mber and the number of its employees who a re making more than $30,000.

Expert Answer

---

Answer to 7.5. Specify the following queries on the data base in Figure 5.5 in SQL. Show the query re sults if each query is appli… . . .