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

Assigment, how to measure marginal utility.?

how to measure marginal utility.?

Central processing unit, The Central Processing Unit : Central Processing U...

The Central Processing Unit : Central Processing Unit (CPU) is the brain of the computer. The intricate electronic circuitry of the CPU performs the computer's tasks of handling d

Network engenering, What role would you assign to each of the four workstat...

What role would you assign to each of the four workstation and any other equipment

Project on ASP .NET MVC 5, I am looking for a project which is based on ASP...

I am looking for a project which is based on ASP.NET MVC 5.Could you please help me ?

Write the steps to use the network setup wizard, Problem Write the step...

Problem Write the steps to use the Network setup wizard. Elaborate the optional subcomponents in the windows component wizard. 1. Click Next to skip past the Welcome screen.

Systems Analysis and Design, Ask question #MiniProfessional and Scientific ...

Ask question #MiniProfessional and Scientific Staff Management (PSSM) is a unique type of temporary staffing agency. Many organizations today hire highly skilled, technical employe

Twisted pair cable, what are daily uses of twisted pair cable in network

what are daily uses of twisted pair cable in network

Data communications and networks, A magazine publisher based in Nairobi has...

A magazine publisher based in Nairobi has branch in Kisumu, and one in Mombasa. The company has kept in touch by telephone and courier service. Each office is networked. The networ

Types of computer, types of computer on the basis of shape, size & resource...

types of computer on the basis of shape, size & resources

Explain briefly about das, Question 1 What is Content Addressable Storage?...

Question 1 What is Content Addressable Storage? Explain the elements of Content Addressable Storage Question 2 Explain briefly about DAS Question 3 Explain about N

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