Ask Question
18 February, 03:11

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.

+2
Answers (1)
  1. 18 February, 04:02
    0
    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.
Know the Answer?
Not Sure About the Answer?
Find an answer to your 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 ...” in 📘 Computers and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers