The couple ask for a few sentences

super86

There is a table to record the working hours of all employees per day. Now all we have to do is add up each person's overtime working hours per day to more than 36 hours per month. Those who exceed 36 * 12 each year are displayed.

nankeny

select
   Employee,
   left (year, month, 4) as year,
   sum (overtime work) as overtime work
from
   (
   select
       Employee,
       convert (varchar (7), date, 120) as month
       sum (overtime work) as overtime work
   from
       table
   group by
       Employee,
       convert (varchar (7), date, 120)
   having
       sum (overtime work)> 36
   ) as t

group by
   Employee,
   left (year, month, 4)
having
   sum (overtime work)> 36 * 12

super86

Thank you upstairs. I just started learning SQL. I have to learn more from you.

zhoutao112

Yes, learned