Computer science, computer science, Basic Computer Science

You recently returned some homework I completed but i left of the final 10 questions. Should not take long just needs some commands interpreted. How much will it cost for me to get them completed? my ticket number is; EM3272012BIL0328_CP
The questions follow:
7. For each department, retrieve the department name and the average salary of all employees
working in that department.
8. Retrieve the average salary of all female employees.
9. Find the name of each employee who works on at least one project located in Houston but
whose department has no location in Houston.
2
10. List the name of each department manager who has no dependents.
11. List the name of each department manager who has no dependents. (do not use SQL operators
and constructors such as NOT IN, NOT EXISTS, MINUS, COUNT)
12. For each employee, show how many employee(s) each supervises.
13. Retrieve the name of employee whose salary is greater than the average salary of all the
employees in department 5.
14. Retrieve the name of employee whose salary is greater than the average salary of his or her
corresponding department.
15. List the social security number of each employee who does not work on any one of projects with
project number 1, 2, or 3.
16. List the social security number of each employee who works on the projects other than the
projects with project number 1, 2, or 3.
17. List the social security number of each employee who works on all the projects with project
number 1 and 2.
18. Retrieve the social security numbers of all direct and indirect supervisees James Borg has.
19. List the name of each department, and the total number of employees with salaries greater than
$30,000, and only the department with more than one employee.
20. List the name of department that has more than one employee who earns more than $30,000.
G. Submit your assignment including A, B, C, D, E and F.
H. For question F, please include query number, query statement, and query execution result for
each query. In your submission, please exclude all the error messages generated during the
execution of SQL statements. For Question C, D, and E, please give your answers in English
without using SQL.

Posted Date: 3/28/2012 2:40:04 PM | Location : United States







Related Discussions:- Computer science, computer science, Assignment Help, Ask Question on Computer science, computer science, Get Answer, Expert's Help, Computer science, computer science Discussions

Write discussion on Computer science, computer science
Your posts are moderated
Related Questions
Question 1 Explain different functions of an operating system. Explain the evolution of operating systems Question 2 Explain process creation and process termination Ques

want to get detail understanding of the types of security policies including enterprise security policy, issues specific policies etc

A string S is said to be "Super ASCII", if it contains the character frequency equal to their ascii values. String will contain only lower case alphabets (''''''''a''''''''-'''''''

QUESTION Developers spend much more time extending and changing code than they did originally while developing it. (a) As a team leader, illustrate how you will introduce to

The Widening Web The idea, the whole world is agog now had accidental origins. Here is how it all began. In early 1969, the U.S. Defence department financed a network fo

QUESTION a) What is Time Division Multiplexing (TDM), illustrate your answer with a diagram b) Describe four types of RTCP messages c) i) What is silence compression in I

Sets of individual statements making up a single code block are known as suites in Python. Composite or complex statements for example if, def while and class are those which neces

FUNCTIONING OF A COMPUTER: Computers have undergone through a long history of evolution. The evolutionary history is often divided into mechanical and electronic era, with ele

I wrote a program that adds up 5x5 matrices by column and row. Now i have to use pointers to rewrite the same code how would do that

Write a method called Grade that takes a numeric score and returns a letter grade. Use the rule that 90 to100 is an A, 80 to 89 a B, 60 to 79 is a C, 45 to 59 is a D, and less th