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

Rooted tree, Ask qu The figure below shows a rooted tree, 756_Find the hei...

Ask qu The figure below shows a rooted tree, 756_Find the height.png 1.1. Find the height/level of the tree as shown above?estion #Minimum 100 words accepted#

System, differance between multiaccess and multitasking

differance between multiaccess and multitasking

Working of web browser, Working of web Browser:   Internet is character...

Working of web Browser:   Internet is characterized by the Client Server Computing that consists of three basic components: The Web client which may be the web browser;

Probability, Mike sells on the average 15 newspapers per week (Monday – Fri...

Mike sells on the average 15 newspapers per week (Monday – Friday). Find the probability that 2.1 In a given week he will sell all the newspapers [7] 2.2 In a given day he will sel

Differentiate Preemptive and Nonpreemptive Scheduling?, The Scheduling algo...

The Scheduling algorithms can be divided into two parts with respect to how they deal with clock interrupts. 1) Nonpreemptive Scheduling: A scheduling

Comp 100, I have an account in my www.itlab.com and i have a test and it s...

I have an account in my www.itlab.com and i have a test and it should do tonight, so do you have any one to help me and do this test and it is about excel

Multiplaxer, what is multiplaxer and truth table, digram

what is multiplaxer and truth table, digram

Excel, how to use excel..

how to use excel..

Types of computer on basis of size and capabilities, Another way of classif...

Another way of classifying a computer system is based upon its size and capabilities: Microcomputers: Microcomputers are systems based on the use of microprocessors. A Micr

Data transmission, DATA TRANSMISSION: When we talk on the telephone we...

DATA TRANSMISSION: When we talk on the telephone we generally transmit a message to someone else. The message is made up of words that we speak into the telephone instrument.

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