Analyze how many minutes where a single interview room had two or more interviewers at once using start_time and end_time.
Assume each row represents one interviewer scheduled in a room. Treat intervals as half-open, so an interviewer ending exactly when another begins does not create overlap. Include rooms with no overlapping time and ignore rows with missing or invalid timestamps.
room_name, overlapping_minutes.room_name ascending.| Column | Type | Description |
|---|---|---|
| session_idPK | INT | Unique identifier for the scheduled interviewer session |
| room_name | VARCHAR(100) | Interview room identifier |
| interviewer_name | VARCHAR(150) | Name of the interviewer assigned to the session |
| start_time | TIMESTAMP | Scheduled session start time |
| end_time | TIMESTAMP | Scheduled session end time |