Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

5. For each employee, list the employee ID, number of projects, and the total percentage of time for the current projects to which she is

image text in transcribed
image text in transcribed
5. For each employee, list the employee ID, number of projects, and the total percentage of time for the current projects to which she is assigned. Include employees not assigned to any project. 6. Find the description of all projects with no employees assigned to them 7. For each project, find the greatest percentage of time assigned to one employee. Solve it two ways: 1) using only WHERE-based join (i.e., no INNER/OUTER/CROSS JOIN) and 2) using some form of JOIN 8. For each employee ID, find the last name of all employees making more money than that employee. Solve it two ways: 1) using only WHERE-based join (i.e., no INNER/OUTER/CROSS JOIN) and 2) using some form of JOIN 9. Rank the projects by revenue. Solve it two ways: 1) using only WHERE-based join d.e., no INNER/OUTER/CROSS JOIN) and 2) using some form of JOIN

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions