Question

Write an SQL statement to show the sum of HoursWorked for each Type of OWNER but exclude services of employees who have an ExperienceLevel of Junior and exclude any Type with less than three members.

Answer 1

To show the sum of HoursWorked for each Type of OWNER but exclude services of employees who have an ExperienceLevel of Junior and exclude any Type with less than three members, you can use the provided SQL statement.

Step-by-step explanation:

To show the sum of HoursWorked for each Type of OWNER but exclude services of employees who have an ExperienceLevel of Junior and exclude any Type with less than three members, you can use the following SQL statement:

SELECT Type, SUM(HoursWorked) AS TotalHours
FROM table_name
WHERE ExperienceLevel <> 'Junior'
GROUP BY Type
HAVING COUNT(Type) >= 3;

This statement selects the Type and calculates the sum of HoursWorked for each Type, excluding records with ExperienceLevel 'Junior' and Types with less than three members.

Answer 2

select sum(HoursWorked)

from OWNER

where ExperienceLevel <> 'Junior'

group by ExperienceLevel

having count(*) >= 3

Step-by-step explanation:

First use the sum function on HoursWorked column of OWNER table. Then put the required condition of not including employees with experience level of Junior. And then use group by function to bulk the results by experience level and group only results with equal to or more than 3 records.