Create a view named as EmpInfo that shows the information

Formulate the following queries: (note, for some queries,
you may need to use the combination of join and subquery or correlated
subquery, together with group by and having clauses).
1.
Create a view named as EmpInfo that shows the
information of each employee and the total number of project he/she
participate. Note, for the employee who do not participate any project, the
count is 0.

2.
Create a view named as EmpInfo that shows the
information of each employee and the total project working hours he/she has.
Note, for the employee who do not participate any project, the project
working hour is 0.

3.
List the name of employee who is working on the
project whose budget is below the division average project budget.

4.
List the name of project that some employee(s)
who is/are working on it make less than divisional average salary.
5. List the total number of division that has 3
employees
6. List
the total number of project that has 2 employees working on it
7. List the total
number of projects accounting division manager works on.
8. List the total
number of projects that ‘joan’ does not work on.
9. List the name of division that has most of the employees
who work on projects. (hint: use having , compare count() to count)
10. List the total number of employees who
have more than 100 project working hours in total.
11. List the name of the division that has more
than one employee whose salary is greater than her/his divisional
average salary (use corelated subquery)
12. List the name of the employee that has the
lowest salary in his division and list the total number of projects
this employee is work on (use corelated subquery)
13. list the name of employee who do more projects than
his/her divisional colleagues (hint : use
group by did , empid, name having count(pid)> ( here is the
correlated subquery that select count(pid) from e’s divisional colleagues
workon record) )
14. List name of division and its total number of employee
and its total number of salary
15. list the name of divisions that have/sponsor project(s)
employee ‘chen’ works on.
16. (bonus) List the name of employee who work on
all project (hint this means that there not exists a project the
employee does not work on, Use NOT EXISTS, note, there is a similar
query in chapter 8).

 

CLICK HERE TO ORDER A SIMILAR PAPER

We pride ourselves in writing quality essays

CLICK HERE TO CONTACT US

Lets Start Working

Plagiarism Free

We use anti-plagiarism software to ensure you get high-quality, unique papers. Besides, our writers have a zero plagiarism mentality

On Time Delivery

Your essay will be delivered strictly within the deadline.  If you have an urgent order, we can do it!

Money Back Guarantee

We offer warranty service, including free revisions, and a right to request a refund incase your expectations are not met!

THE BEST PAPER WRITER HELPER

Our Advantage

  • Say “NO” to plagiarism – FREE plagiarism report as an addition to your paper
  • The lowest prices that fit excellent quality
  • Authorship – you are the one who possesses the paper. We DO NOT re-sale or re-use any of them.

OUR PAPER WRITER HELPER GOODIES

Our Freebies

  • Free Cover Page
  • Free Revisions
  • Free Reference Page
  • Free 24/7 support

Pin It on Pinterest

Share This