Write a query to compute percentiles of bet placement latency across different geographical regions using advanced aggregation functions.
Use the provided region and bet placement data. Ignore placements whose latency is NULL, but retain regions with no valid latency measurements.
region_id, region_name, p50_latency_ms, p90_latency_ms, and p95_latency_ms.region_name ascending, then region_id ascending.| Column | Type | Description |
|---|---|---|
| region_idPK | INT | Unique geographical region identifier |
| region_name | VARCHAR(100) | Geographical region name |
| Column | Type | Description |
|---|---|---|
| placement_idPK | INT | Unique bet placement identifier |
| region_id | INT | Region associated with the placement |
| latency_ms | INT | Bet placement latency in milliseconds |