ClearOps (Germany) Interview Question

How do you select this information from this SQL table