Resolve Sensor Threshold Checks

Problem

A monitoring system stores named numeric readings and a list of comparison checks between two of those readings.

Table: `Gauges`

```text
+--------+---------+
| Column | Type |
+--------+---------+
| tag | varchar |
| reading| int |
+--------+---------+
tag is the primary key (a short label, up to 3 characters).
reading is the current numeric value of that gauge.
```

Table: `Checks`

```text
+-----------+---------+
| Column | Type |
+-----------+---------+
| lhs | varchar |
| comparator| varchar |
| rhs | varchar |
+-----------+---------+
lhs and rhs are gauge tags. comparator is one of '>', '<', or '='.
Each row asks whether the comparison lhs comparator rhs holds.
```

For every check, return its three columns plus a `verdict` column equal to the string `pass` when the comparison is true and `fail` otherwise.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 6 rows with the columns lhs, comparator, rhs, verdict.

Starter code (SQL)

SELECT *
FROM Gauges;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• 7-Day vs 28-Day Rolling Avg DivergenceMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium