We have to come with a SQL logic.
We have more employee than Seat allocated in Office
Constraints for 20 Team member we have 12 seats
Also, we have ensure out of 05 workdays each employee has to come 03 days.
We need to come up with a logic wherein seat and days are allocated and rotated every 4 weeks with a complexity that if a week has a holiday let's say 25th Dec is Christmas and is on Friday hence that week will have only 04 work day , in that case same seat will be allocated to multiple employee as 3 day rule stays