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.

Question

Computers & Technology

Libby Frye

3 January, 00:40

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.

+4

Answers (1)

Know the Answer?

Maxim Dyer · Answer 1

select sum (HoursWorked)

from OWNER

where ExperienceLevel 'Junior'

group by ExperienceLevel

having count (*) > = 3

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.