What is a REST API?
For this SQL exercise, analyze recorded REST API requests. Write a query that summarizes successful requests for each endpoint.
endpoint, successful_request_count, and avg_response_time_ms| Column | Type | Description |
|---|---|---|
| request_idPK | INT | Unique request identifier |
| endpoint | VARCHAR(100) | REST API endpoint that received the request |
| http_method | VARCHAR(30) | HTTP method used by the request |
| status_code | INT | HTTP response status code |
| response_time_ms | NUMERIC(10,2) | Response time in milliseconds |
| requested_at | TIMESTAMP | Timestamp when the request was received |