Practice Find Overbooked Employees

The employees table contains employee_id (integer primary key), employee_name (text), and department (text). The meetings table contains meeting_id (integer primary key), employee_id, meeting_date (date), meeting_type (Team, Client, or Training), and duration_hours (decimal). Assume a 40-hour work week. Group each employee's meetings into calendar weeks running Monday through Sunday, summing all meeting types. A week qualifies only when the total exceeds 20 hours; exactly 20 does not qualify. Return employees with at least two qualifying weeks. Output employee_id, employee_name, department, and meeting_heavy_weeks. Sort by that count descending, then name ascending. Practice approach: Aggregate hours by employee and the Monday date of the week. Filter with SUM(duration_hours) > 20, then count the qualifying weeks per employee and require COUNT(*) >= 2. Join employees for the display fields. Use a week-start date, not a week number without its year.