Given a log file containing request records for different domains, output the number of requests for each domain.
Use the canonical domain list and request log records provided. Include registered domains with zero requests, and exclude request records whose domain is not present in the canonical list.
domain and request_countrequest_count descending, then domain ascending to break ties| Column | Type | Description |
|---|---|---|
| domain_idPK | INT | Canonical identifier for a domain |
| domain_name | VARCHAR(255) | Registered domain name |
| Column | Type | Description |
|---|---|---|
| request_idPK | INT | Unique request record identifier |
| domain_id | INT | Identifier of the requested domain |
| requested_at | TIMESTAMP | Timestamp when the request was recorded |
| request_path | VARCHAR(255) | Requested URL path |