--白天大班
select J_User_id,SUM(J_Hour) as 课时1 from ChildrenTeachingLog where datepart(hh,J_EDate)<19 and J_StudentNo>=5 group by J_User_id select J_User_id,SUM(J_Hour) as 课时1&n
select J_User_id,SUM(J_Hour) as 课时1 from ChildrenTeachingLog where datepart(hh,J_EDate)<19 and J_StudentNo>=5 group by J_User_id select J_User_id,SUM(J_Hour) as 课时1&n