---

SELECT 
    pl.TabNumber AS [Табельный номер],
    pl.Name AS [Фамилия],
    pl.FirstName AS [Имя],
    pl.MidName AS [Отчество],
    CAST(pld.DeviceTime AS DATE) AS [Дата],
    MIN(pld.DeviceTime) AS [Первый вход],
    MAX(pld.DeviceTime) AS [Последний выход]
FROM [X-SKUD].dbo.pLogData pld
LEFT JOIN [X-SKUD].dbo.pList pl ON pl.ID = pld.HozOrgan
WHERE pl.ID IS NOT NULL 
  AND pl.TabNumber IS NOT NULL
  AND pld.DeviceTime >= CAST(GETDATE() AS DATE) -- За сегодня
GROUP BY 
    pl.TabNumber, 
    pl.Name, 
    pl.FirstName, 
    pl.MidName, 
    CAST(pld.DeviceTime AS DATE)
ORDER BY pl.Name;