Need help Select Query to identify work hours per day
Budget: $10 – $30 USD
Hi,
I need support for a MySQL Select Creation Query for the working hours. I have a sql table with Start and End working time. Both in DateTime format. This working time must be classified for four column such regular work, overtime and so on. I created a description for seeked columns and conditions. Please have look and let me know if you can solve it
Attached is sql-table and the same table as csv table and a ducument that describe the case.
Please keep in mind that I need a SELECT Query to create a View.
I need support for a MySQL Select Creation Query for the working hours. I have a sql table with Start and End working time. Both in DateTime format. This working time must be classified for four column such regular work, overtime and so on. I created a description for seeked columns and conditions. Please have look and let me know if you can solve it
Attached is sql-table and the same table as csv table and a ducument that describe the case.
Please keep in mind that I need a SELECT Query to create a View.