By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
11 rows affected
| Name | LastStatus | LastStatusCount |
|---|---|---|
| Machine1 | Fault | 3 |
| Machine2 | Active | 3 |
| Machine3 | Active | 1 |
11 rows affected
| Name | LastStatus | LastStatusCount |
|---|---|---|
| Machine1 | Fault | 3 |
| Machine2 | Active | 3 |
| Machine3 | Active | 1 |