Explain how SSL certificates and HTTP cache headers affect a web service in production.
Using the provided service, certificate, cache-header, and request tables, write a query that summarizes these production effects for each service as of 2025-03-08.
service_name, endpoint, certificate_status, cache_policy, request_count, average_response_ms, and cache_hit_rate_percent.valid, expiring, expired, or missing, and cache policies as revalidatable, cacheable, no-cache, or missing.endpoint ascending.| Column | Type | Description |
|---|---|---|
| service_idPK | INT | Unique service identifier |
| service_name | VARCHAR(100) | Service display name |
| endpoint | VARCHAR(150) | HTTP endpoint path |
| Column | Type | Description |
|---|---|---|
| cert_idPK | INT | Unique certificate identifier |
| service_id | INT | Referenced service |
| issued_at | DATE | Certificate issue date |
| expires_at | DATE | Certificate expiration date |
| tls_version | VARCHAR(20) | Negotiated TLS version |
| is_current | BOOLEAN | Whether this is the active certificate |
| Column | Type | Description |
|---|---|---|
| header_idPK | INT | Unique header observation |
| service_id | INT | Referenced service |
| captured_at | DATE | Date headers were captured |
| cache_control | VARCHAR(100) | Observed Cache-Control header |
| max_age_seconds | INT | Maximum cache lifetime in seconds |
| etag_present | BOOLEAN | Whether an ETag header was present |
| Column | Type | Description |
|---|---|---|
| request_idPK | INT | Unique request identifier |
| service_id | INT | Referenced service |
| requested_at | DATE | Request date |
| status_code | INT | HTTP response status code |
| response_ms | DECIMAL(10,2) | Response latency in milliseconds |
| cache_hit | BOOLEAN | Whether the response was served from cache |