ID          TimeStamp
310963627   2018-01-10 15:30:21.000
310963562   2018-01-10 15:29:47.000
310963595   2018-01-10 15:29:04.000
310963517   2018-01-10 15:28:21.000
310963548   2018-01-10 15:27:41.000
310963469   2018-01-10 15:27:02.000
310963500   2018-01-10 15:26:17.000
310963436   2018-01-10 15:25:39.000
310963422   2018-01-10 15:24:58.000

Shift   1st       2nd        3rd
Start   6:30 AM   2:30 PM    10:30 PM
End     2:30 PM   10:30 PM   6:30 AM
Hours   8:00      8:00       8:00

SELECT
        [Shift],
        Count([ID]) as Assembled

FROM(
    SELECT _60.*,
        CASE WHEN (
        CONVERT(CHAR(5), Timestamp, 114) between '06:30' and '14:30'
        )
                THEN LEFT(CAST(TimeStamp AS DATE),10)+':1st'

             WHEN (
        CONVERT(CHAR(5), Timestamp, 114) between '14:30' and '22:30'
        )
                THEN LEFT(CAST(TimeStamp AS DATE),10)+':2nd'

            WHEN (
        CONVERT(CHAR(5), Timestamp, 114) between '22:30' and '24:00'
        )
                THEN LEFT(CAST(DATEADD(DAY, 1, TimeStamp) AS DATE),10)+':3rd'

            WHEN (
        CONVERT(CHAR(5), Timestamp, 114) between '00:00' and '06:30'
        )
                THEN LEFT(CAST(DATEADD(DAY, 0, TimeStamp) AS DATE),10)+':3rd'

           END AS [Shift]
    FROM dbo.Offload _60
) _60
where TimeStamp > (DATEADD(DAY, -150, GETDATE()))

GROUP BY    [Shift]
order by CAST(LEFT([shift],10) as date) desc

Shift           Assembled
2018-01-10:1st  389
2018-01-10:2nd  39
2018-01-10:3rd  406
2018-01-09:1st  245
2018-01-09:2nd  334
2018-01-09:3rd  125
2018-01-08:1st  441
2018-01-08:2nd  263
2018-01-08:3rd  430
2018-01-07:1st  390
2018-01-07:2nd  456
2018-01-07:3rd  152

1st 2nd 3rd
2018-01-10  389 39  406
2018-01-09  245 334 125
2018-01-08  441 263 430
2018-01-07  390 456 152

SELECT
    CAST(DATEADD(MINUTE, -390, TimeStamp) AS DATE) AS [Date]
    , SUM(CASE
        WHEN CAST(TimeStamp AS TIME) BETWEEN '06:30:00.000' AND '14:29:59.999'
        THEN 1
        ELSE 0
    END) AS [1st]
    , SUM(CASE
        WHEN CAST(TimeStamp AS TIME) BETWEEN '14:30:00.000' AND '22:29:59.999'
        THEN 1
        ELSE 0
    END) AS [2nd]
    , SUM(CASE
        WHEN CAST(TimeStamp AS TIME) < '06:30:00.000'
            OR CAST(TimeStamp AS TIME) >= '22:30:00.000'
        THEN 1
        ELSE 0
    END) AS [3rd]
FROM Offload
GROUP BY CAST(DATEADD(MINUTE, -390, TimeStamp) AS DATE)

ID          TimeStamp
----------- -----------------------
310963422   2018-01-09 22:31:58.000
310963422   2018-01-09 23:52:30.000
310963422   2018-01-10 00:01:02.000
310963422   2018-01-10 04:08:45.000
310963422   2018-01-10 06:35:23.000
310963627   2018-01-10 15:30:21.000
310963562   2018-01-10 15:29:47.000
310963595   2018-01-10 15:29:04.000
310963517   2018-01-10 15:28:21.000
310963548   2018-01-10 15:27:41.000
310963469   2018-01-10 15:27:02.000
310963500   2018-01-10 15:26:17.000
310963436   2018-01-10 15:25:39.000
310963422   2018-01-10 15:24:58.000
310963500   2018-01-10 22:26:17.000
310963436   2018-01-10 22:25:39.000
310963422   2018-01-10 22:31:58.000

Date       1st         2nd         3rd
---------- ----------- ----------- -----------
2018-01-09 0           0           4
2018-01-10 1           11          1