Группировка

        SELECT 
    EmployeeSet.Name AS Name,
    Post,
    CONVERT(VARCHAR(8), ServDate, 04) AS ServDate,
    Code,
    sum(Quantity) as usl,
    Description,
    Length,     
    sum(Length)as minut,
    
    (CONVERT(DECIMAL(5,2),(CASE ServicesSet.PriceAdditional
    WHEN 7 THEN 1.0 *Length/60 else sum(Length)/60
 
    END))) as Sdel
 
    
 
    
 
FROM
    [OCRI].[dbo].ServedSet,[OCRI].[dbo].ClientsSet,[OCRI].[dbo].[VisitsSet],
                    
        
            [OCRI].[dbo].ServicesSet,
    
 
    
        [OCRI].[dbo].EmployeeSet
            
WHERE
        IsServed = '1' and
            Served_Services = ServicesSet.Id
        and  Served_Employee = EmployeeSet.Id
        and VisitsSet.id=Served_Visits
        and ClientsSet.id=Visits_Clients
         
        and ServDate between'29.06.2023'and '16.07.2023'
        
        and ServicesSet.Type in ('СБР','СПедР','ССР','СПедР','СПсихР','СКР','АФКР','ПО')  
            
        group by ServDate,EmployeeSet.Name,Post,Code,Quantity,Length,Description,PriceAdditional
                        order by Name,ServDate