SQL QUERY TO GET THE COUNT OF DAYS AN EMPLOYEE WORKED IN A SHIFT
Summary:
- Objective: I need a SQL query to determine how many days an employee worked in a specific shift within a week.
- Context:
- Part-time employees may work 1, 2, or 3 days per week, depending on their assigned shift.
- Each workday is assumed to be 8 hours.
- If an employee worked 24 hours in a week, that means they worked 3 days (8 * 3 = 24).
- Challenge: I am using specific tables and SQL queries but cannot directly retrieve the count of working days for an employee in a week. In the below case this employee has worked 3 days in a week. And I want the count as 3 . Please suggest how can I achieve the working day count as 3.
0