Question

Management is concerned that some employees are not putting in sufficient work hours on assigned projects 1, 2, 3. List the names (last and first) of employees who worked on one of these three projects combined. Hint: compute the average hours worked on projects 1, 2, 3 in a sub query.

Answer 1

Please find below query and don't forget to give a Like.

Question:

List the names (last and first) of employees who worked on one of these three projects combined

Answer:

Select Last_name,first_name from employees where project_no=1 or project_no=2 or project_no=3;

Explanation:

Since mentioned one of these 3 projects combined we took Or in where clause

Considering the hint:

Select Last_name,first_name from employees having  avg(work_hours) in

(Select avg(work_hours) from employees where project_no=1 or project_no=2 or project_no=3);