For each employee: first_name, dept_name (may be empty), projects (count, 0 if none), hours (sum, 0 if none) and load: 'Free' (0 h), 'Normal' (1–40 h), 'Overloaded' (> 40 h).
20 rows with columns first_name, dept_name, projects, hours, load — first 3 shown:
| # | |||||
|---|---|---|---|---|---|
| 1 | Rahul | Engineering | 2 | 25 | Normal |
| 2 | Priya | Engineering | 2 | 40 | Normal |
| 3 | Arjun | Engineering | 2 | 45 | Overloaded |
Run your code to see the output here.