Computer science, computer science, Basic Computer Science

Assignment Help:
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.


Related Discussions:- Computer science, computer science

Describe, Question: a) Illustrate, in detail, what is virtual memory? ...

Question: a) Illustrate, in detail, what is virtual memory? b) The Memory Management Unit is responsible for the translation of virtual addresses to their corresponding phy

Working of a computer, Working of a Computer Computer may be div...

Working of a Computer Computer may be divided into the following units     Input Unit     Main Memory or Primary Storage Unit     Arithmetic-Logic Unit

Data Type Conversion, Sometimes you may drop to perform conversions among t...

Sometimes you may drop to perform conversions among the built-in types. To translate between types you just use the type name as a function. There are quite a few built-in function

Project, My son has a project assignment he has problem with. The only thin...

My son has a project assignment he has problem with. The only thing is, it is due in 20 mins. can someone be able to help him? if so, how much is the fee?

Project of interactive powerpoint in human computer , Hi There, can you h...

Hi There, can you help me with my small project please, i have sent it yesterday and you dont replay. can you please ethir lem me know you can do it or no Regrads Meshari

Describe the binary search algorithm, QUESTION 1 Describe the binary se...

QUESTION 1 Describe the binary search algorithm using an example of your own. QUESTION 2 (a) By showing all your workings, give a big-O estimate for f(x) = (x + 1)lo

Data base, advantages of file base system

advantages of file base system

History of e-mail, History of E-mail: Internet based E-mail system was...

History of E-mail: Internet based E-mail system was designed by a Computer engineer - Ray Tomlinson in late 1971 while working with ARPANET. Tomlinson used a file transfer pro

Data type, Data Type:  Data Type: Anything that is processed by a comp...

Data Type:  Data Type: Anything that is processed by a computer is called data. There are different types of data that can be given to the computer for processing. A  data typ

Technology, We normally think of the arts as very different from technologi...

We normally think of the arts as very different from technologies in spite of the fact that art (with perhaps a few exceptions) is practiced with the help of technology. This pract

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd