Flagging Patterns in Request Lines

Problem

Table: `request_log`

```text
+-------------+---------+
| Column Name | Type |
+-------------+---------+
| line_id | int |
| path_text | varchar |
| service | varchar |
+-------------+---------+
line_id is the primary key for this table.
Each row holds one captured request path and the service that emitted it.
```

A reliability team wants four diagnostic flags computed for every captured request line, based on its `path_text`:

- `is_api`: 1 if the path begins with `/api`.
- `is_versioned`: 1 if the path ends with `v1`, `v2`, or `v3`.
- `has_admin`: 1 if the path contains the substring `admin`.
- `has_double_slash`: 1 if the path contains three or more consecutive slashes (`///`).

Return every row from `request_log` together with the four flag columns, ordered by `line_id`.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 7 rows with the columns line_id, path_text, service, is_api, is_versioned, has_admin, has_double_slash.

Starter code (SQL)

SELECT *
FROM request_log;

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