Question: Specify the following additional queries on the database of Figure 3.5 in SQL. Show the query results if applied to the database of Figure 3.6.

Specify the following additional queries on the database of Figure 3.5 in SQL. Show the query results if applied to the database of Figure 3.6.
(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?

Step by Step Solution

★★★★★

3.39 Rating (174 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a SELECT DNAME COUNT FROM DEPARTMENT EMPLOYEE WHERE DNU... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

888-CS-DB (2291).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

In SQL, specify the following queries on the database specified in Figure 3.5 using the concept of nested queries and the concepts described in this chapter. a. Retrieve the names of all employees...

Specify the following queries in SQL on the database schema of Figure 1.2. (a) Retrieve the names and major departments of all straight-A students (students who have a grade of A in all their...

Specify the following queries on the COMPANY relational database schema shown in Figure 3.5, using the relational operators discussed in this chapter. Also show the result of each query as it would...

7-1 [6 points] Specify the following additional queries on the database in Figure 5.5 in SQL Show the query results if applied to the database state in Figure 5.6 (a) For each department whose...

7.5 - Specify the following additional queries on the database of Figure 5.5 in SQL. Show the query results if applied to the database of Figure 5.6. (a) For each department whose average employee...

A nested query is query within a query. More specifically, a nested query is a parenthesized query that can be used as a value in a number of places, such as instead of a relation or a selection...

Please help with Database Relational Algebra and Nested Queries. A nested query is a query within a query. More specifically, a nested query is a parenthesized query whose result can be used as a...

A nested query is a query within a query. More specifically, a nested query is a parenthesized query whose result can be used as a value in a number of places, such as instead of a relation. Specify...

Dont copy from others!!!!!! if you copy others, ill report 2. Specify the following 5 queries in SQL on the Salesrep database schema of Figure 1.1. (Total for que 2 is 10 marks) i. List all your 5...

NASA/SP-2011-3422 Version 1.0 November 2011 NASA Risk Management Handbook NASA/SP-2011-3422 Version 1.0 NASA Risk Management Handbook National Aeronautics and Space Administration NASA Headquarters...

If a company were thinking of converting from single step to multi-step for an income statement to take out a loan. What advice should they be given, especially when the net income would remain the...

During some actual expansion and compression processes in piston - cylinder devices, the gases have been observed to satisfy the relationship PVn = C, where n and C are constants. Calculate the work...

Dupree Company produces three products - DBB - 1 , DEB - 2 , and DBB - 3 from a joint process. Each product may be sold at the split - off point or processed further. Additional processing requires...

On December 20, 2011, stock in Exxon Mobil was selling at 81.63. (a) Use the BlackScholes formula to compute the value of an April 12 call (t D 0:3123 years) with strike 70, assuming an interest rate...

Using the attributes you provided for the EER diagram in Exercise 4.27, map the complete schema into a set of relations. Choose an appropriate option out of 8A thru 8D from Section 9.2.1 in doing the...

Is it possible to successfully map a binary M:N relationship type without requiring a new relation? Why or why not?

Map the EER diagrams in Figures 4.9 and 4.12 into relational schemas. Justify your choice of mapping options. Figures 4.9 Figure 4.12 Salary Shift Model Capacity Weight M. WORKS ON N EMPLOYEE N...

1. Compute the impact on the companys overall net operating income if the company discontinued one of its departments based on the following facts: The contribution margin in the department is...

The Yurdone Corporation wants to set up a private cemetery business. According to the CFO, Barry M. Deep, business is "looking up." As a result, the cemetery project will provide a net cash inflow of...

First City Bank pays 7 percent simple interest on its savings account balances, whereas Second City Bank pays 7 percent interest compounded annually. If you made a deposit of \$12,000 in each bank,...