By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| run | host | status | field_ip | control_ip | field_data | control_data |
|---|---|---|---|---|---|---|
| 1 | 1 | no_control | 10.0.0.1 | null | foo | null |
| 1 | 2 | good | 10.0.0.1 | 10.0.0.1 | bar | bar |
| 1 | 3 | problem_0 | 10.0.0.1 | 192.168.2.1 | bar | zaphod |
| 1 | 3 | problem_1 | 10.0.0.1 | 192.168.1.1 | bar | wallace |
| 1 | 3 | problem_2 | 10.0.0.2 | 192.168.1.1 | baz | wallace |
SELECT 5