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

Explain data movement ?, In any program it is essential to move the data in...

In any program it is essential to move the data in the memory and in the CPU registers; there are a number of ways to do this: it can copy data in the memory to a number of registe

Word processing software, Word Processing Software : The main use for word...

Word Processing Software : The main use for word processing is found in secretarial offices and small publishing companies. However, if you are involved in generating your own cor

Languages used in artificial intelligence, R e presentations/Languages Us...

R e presentations/Languages Used: Many people are taught Artificial Intelligence with the opening line: "The three most essential things in Artificial Intelligence are repres

Explain the important concepts of modern cpu, Question 1 Explain the impor...

Question 1 Explain the important concepts of modern CPU CISC vs. RISC CPUs Circuit Size and Die Size Processor Speed Processor Cooling System Clocks Architect

Discuss about the descriptor classes, Question 1 List down any six feature...

Question 1 List down any six features of a Smartphone Question 2 Give a brief note on a) Internal Flash Disk. b) Use of C++ in Symbian OS Question 3 What are the naming

Input/output (i/o) unit, Input/output (I/o) unit: This unit provides th...

Input/output (I/o) unit: This unit provides the interface between the computer and the computer peripherals. A computer peripheral is any unit, which is attached to, but is no

Assignment, I have an assignment i need it to get it done How much would I...

I have an assignment i need it to get it done How much would I be charged for that?

Software licensing, Software Licensing: Until early 1970's, sharing of...

Software Licensing: Until early 1970's, sharing of software was the accepted norm. Hardware came bundled with software products which could be freely redistributed and the acc

Describe what are system software and application software, Problem: (a...

Problem: (a) Using appropriate examples describe what are System software and Application Software. (b) Explain four tasks of file management a user frequently performs i

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