Group by month, day, and shifts

[Eike Saathoff]

Hi there,

I have to write a query where I group production data into month, day and the 3 working shifts we are running inside our company.

Month and day where no problem and I want to realize the 3 shifts with a case statement.

Shifts are divided from 6am-2pm, 2pm-10pm and 10pm to 6am. How can I write the case for the night shift that starts at 10pm at the day before and ends on 6am on the next day?

Thanks in advance.