By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 11 Duplicates: 0 Warnings: 0
| area_date | area_name | node_address |
|---|---|---|
| 2024-01-01 08:15:00 | area1 | 1 |
| 2024-01-01 08:20:00 | area1 | 1 |
| 2024-01-01 08:25:00 | area1 | 1 |
| 2024-01-01 08:30:00 | area1 | 1 |
| 2024-01-01 08:45:00 | area1 | 1 |
| 2024-01-01 09:00:00 | area1 | 1 |
| 2024-01-01 08:15:00 | area2 | 2 |
| 2024-01-01 08:20:00 | area2 | 2 |
| 2024-01-01 09:00:00 | area2 | 1 |
| 2024-01-01 09:05:00 | area2 | 2 |
| 2024-01-01 09:10:00 | area2 | 2 |
| area_name | total_minutes_in_area |
|---|---|
| area1 | 25 |
| area2 | 15 |